Business Reporting Paper

profileddc75
Assignment1Week4REVISED.xlsx
Home>Applied Sciences homework help>Business Reporting Paper

Sheet1

$ 1,000,000 $ 200,000 6
($924,575.93)
1200 per year for 10 years
$13,756.66
1200 per year for 10 years we want $ 17,000
7.53%
1200 per year for 12000 3 rate 3.00%
8.88 years
321.2 days
10.7066666667 months
borrow $ 22,000 2.00% 5 years
($4,667.48) ($385.61)
($23,136.64)
$ 1,136.64

Sheet2

Investment Opportunity Loan to Fund Total Paid on Loan
Future Value $ 350,000 Loan Amount $300,000 $300,000.00 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50%
Payment $ 7,000 Months 60 $ 275,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000
Rate 5.75% Interest Rate 5.75% $ 280,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000
Years 5 $ 285,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000
$ 290,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000
$ 295,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000
Value ($294,334.68) Payment ($5,765.03) $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000
Total Paid ($345,901.83) $ 305,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000
Interest Rate 0.48% $ 310,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000
$ 315,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000 $ 300,000
Interest Rate 5765.030463232658
3.00% $ 5,390.61
3.25% $ 5,424.00
3.50% $ 5,457.52
3.75% $ 5,491.18
4.00% $ 5,524.96
4.25% $ 5,558.87
4.50% $ 5,592.91
4.75% $ 5,627.07
5.00% $ 5,661.37
5.25% $ 5,695.80
5.50% $ 5,730.35
5.75% $ 5,765.03
6.00% $ 5,799.84
6.25% $ 5,834.78
6.50% $ 5,869.84
Prepared by Derrek Carter