Question
In: Finance
Your dream boat costs $100,000. You have $20,000 but you need to borrow the remaining $80,000....
Your dream boat costs $100,000. You have $20,000 but you need to borrow the remaining $80,000. Your bank offers you a loan with the following characteristics: APR of 5%, monthly payments, a maturity of 5 years.
Assume that you can afford the original loan the bank offered you. Now consider the last month of your loan (the last month during which you make a payment). What is your balance at the end of the month? What is your balance at the beginning of the month? How much did you pay in interest during that month? How much did you pay in amortization during that month?
Solutions
Expert Solution
EMI = Loan / PVAF (r%, n)
PVAF (r%, n) = Sum [ PVF(r%, n) ]
PVF (r%, n) = 1 /(1+r)^n
r -Int Rate per month
n - No. of Months
EMI = Loan / PVAF (r%, n)
= $ 80000 / PVAF ( 0.4167% , 60 )
= $ 80000 / 52.9907
= $ 1509.70
Loan AMortization:
| Month | Opening Balance | Instalment | Interest | Principal Repay | Clsoing Bal |
| 1 | $ 80,000.00 | $ 1,509.70 | $ 333.33 | $ 1,176.37 | $ 78,823.63 |
| 2 | $ 78,823.63 | $ 1,509.70 | $ 328.43 | $ 1,181.27 | $ 77,642.37 |
| 3 | $ 77,642.37 | $ 1,509.70 | $ 323.51 | $ 1,186.19 | $ 76,456.18 |
| 4 | $ 76,456.18 | $ 1,509.70 | $ 318.57 | $ 1,191.13 | $ 75,265.05 |
| 5 | $ 75,265.05 | $ 1,509.70 | $ 313.60 | $ 1,196.09 | $ 74,068.95 |
| 6 | $ 74,068.95 | $ 1,509.70 | $ 308.62 | $ 1,201.08 | $ 72,867.88 |
| 7 | $ 72,867.88 | $ 1,509.70 | $ 303.62 | $ 1,206.08 | $ 71,661.79 |
| 8 | $ 71,661.79 | $ 1,509.70 | $ 298.59 | $ 1,211.11 | $ 70,450.68 |
| 9 | $ 70,450.68 | $ 1,509.70 | $ 293.54 | $ 1,216.15 | $ 69,234.53 |
| 10 | $ 69,234.53 | $ 1,509.70 | $ 288.48 | $ 1,221.22 | $ 68,013.31 |
| 11 | $ 68,013.31 | $ 1,509.70 | $ 283.39 | $ 1,226.31 | $ 66,787.00 |
| 12 | $ 66,787.00 | $ 1,509.70 | $ 278.28 | $ 1,231.42 | $ 65,555.58 |
| 13 | $ 65,555.58 | $ 1,509.70 | $ 273.15 | $ 1,236.55 | $ 64,319.03 |
| 14 | $ 64,319.03 | $ 1,509.70 | $ 268.00 | $ 1,241.70 | $ 63,077.33 |
| 15 | $ 63,077.33 | $ 1,509.70 | $ 262.82 | $ 1,246.88 | $ 61,830.45 |
| 16 | $ 61,830.45 | $ 1,509.70 | $ 257.63 | $ 1,252.07 | $ 60,578.38 |
| 17 | $ 60,578.38 | $ 1,509.70 | $ 252.41 | $ 1,257.29 | $ 59,321.09 |
| 18 | $ 59,321.09 | $ 1,509.70 | $ 247.17 | $ 1,262.53 | $ 58,058.56 |
| 19 | $ 58,058.56 | $ 1,509.70 | $ 241.91 | $ 1,267.79 | $ 56,790.77 |
| 20 | $ 56,790.77 | $ 1,509.70 | $ 236.63 | $ 1,273.07 | $ 55,517.70 |
| 21 | $ 55,517.70 | $ 1,509.70 | $ 231.32 | $ 1,278.37 | $ 54,239.33 |
| 22 | $ 54,239.33 | $ 1,509.70 | $ 226.00 | $ 1,283.70 | $ 52,955.63 |
| 23 | $ 52,955.63 | $ 1,509.70 | $ 220.65 | $ 1,289.05 | $ 51,666.58 |
| 24 | $ 51,666.58 | $ 1,509.70 | $ 215.28 | $ 1,294.42 | $ 50,372.16 |
| 25 | $ 50,372.16 | $ 1,509.70 | $ 209.88 | $ 1,299.81 | $ 49,072.34 |
| 26 | $ 49,072.34 | $ 1,509.70 | $ 204.47 | $ 1,305.23 | $ 47,767.11 |
| 27 | $ 47,767.11 | $ 1,509.70 | $ 199.03 | $ 1,310.67 | $ 46,456.44 |
| 28 | $ 46,456.44 | $ 1,509.70 | $ 193.57 | $ 1,316.13 | $ 45,140.31 |
| 29 | $ 45,140.31 | $ 1,509.70 | $ 188.08 | $ 1,321.61 | $ 43,818.70 |
| 30 | $ 43,818.70 | $ 1,509.70 | $ 182.58 | $ 1,327.12 | $ 42,491.58 |
| 31 | $ 42,491.58 | $ 1,509.70 | $ 177.05 | $ 1,332.65 | $ 41,158.93 |
| 32 | $ 41,158.93 | $ 1,509.70 | $ 171.50 | $ 1,338.20 | $ 39,820.72 |
| 33 | $ 39,820.72 | $ 1,509.70 | $ 165.92 | $ 1,343.78 | $ 38,476.94 |
| 34 | $ 38,476.94 | $ 1,509.70 | $ 160.32 | $ 1,349.38 | $ 37,127.57 |
| 35 | $ 37,127.57 | $ 1,509.70 | $ 154.70 | $ 1,355.00 | $ 35,772.56 |
| 36 | $ 35,772.56 | $ 1,509.70 | $ 149.05 | $ 1,360.65 | $ 34,411.92 |
| 37 | $ 34,411.92 | $ 1,509.70 | $ 143.38 | $ 1,366.32 | $ 33,045.60 |
| 38 | $ 33,045.60 | $ 1,509.70 | $ 137.69 | $ 1,372.01 | $ 31,673.59 |
| 39 | $ 31,673.59 | $ 1,509.70 | $ 131.97 | $ 1,377.73 | $ 30,295.87 |
| 40 | $ 30,295.87 | $ 1,509.70 | $ 126.23 | $ 1,383.47 | $ 28,912.40 |
| 41 | $ 28,912.40 | $ 1,509.70 | $ 120.47 | $ 1,389.23 | $ 27,523.17 |
| 42 | $ 27,523.17 | $ 1,509.70 | $ 114.68 | $ 1,395.02 | $ 26,128.15 |
| 43 | $ 26,128.15 | $ 1,509.70 | $ 108.87 | $ 1,400.83 | $ 24,727.32 |
| 44 | $ 24,727.32 | $ 1,509.70 | $ 103.03 | $ 1,406.67 | $ 23,320.65 |
| 45 | $ 23,320.65 | $ 1,509.70 | $ 97.17 | $ 1,412.53 | $ 21,908.12 |
| 46 | $ 21,908.12 | $ 1,509.70 | $ 91.28 |
 jeff jeffy answered 2 years agoRelated SolutionsYou are thinking of purchasing a house that costs $230,000. You have $20,000 in cash for a down payment, but you need to borrow the rest of the purchase price.
You are thinking of purchasing a house that costs $230,000. You have $20,000 in cash for a down payment, but you need to borrow the rest of the purchase price. The bank is offering a 30-year mortgage that requires monthly payments and has an annual interest rate of 4.55%. What will your monthly payments be if you sign up for this mortgage? Create the amortization schedule on a monthly basis using Excel. Calculate the total amount of interest paid...
You just bought a house for $300,000. You put $100,000 as a down payment and borrow the remaining $200,000 from a bank.You just bought a house for $300,000. You put $100,000 as a
down payment and borrow the remaining $200,000 from a bank. You
take out a 30-year mortgage that charges you 6 percent APR but with
monthly compounding.
A. (15 points) How much is your monthly mortgage payment? Show your
work.
B. (5 points) How much of your second mortgage payment goes towards
interest? Show your work.
your firm needs a computerized line boring machine which costs 80,000 and requires 20,000 in maintenance...your firm needs a computerized line boring machine which costs
80,000 and requires 20,000 in maintenance for each year of its
three year life. After three years, the salvage value will be zero.
The machine falls into the class 10 equipment category (cca rate
30%). Assume a tax rate of 34% and a discount rate of 10%. What is
the projects EAC?
A) -2,374
B) -37,539
C) -32,905
You currently have $60,000 in your bank account and you will need a total of $100,000...You currently have $60,000 in your bank account and you will
need a total of $100,000 in 5 years to pay for a down payment on a
house. What interest rate do you need to earn in order to have
$100,000 in your bank account 5 years from now?
If you borrow the entire fund of your renovation project now (e.g. $100,000)If you borrow the entire fund of your renovation project now (e.g. $100,000) from a bank at an interest of 6% compounded daily and the project takes 2 years to complete, what would be the actual value of your renovation work at completion?
My dream car costs $15,000 A) Calculate the monthly payments on your dream car if the...My dream car costs $15,000
A) Calculate the monthly payments on your dream car if the
annual interest rate is 4%, and the term of the loan is 5
years.
B) Calculate how much you would have to save every month to
purchase your dream car in 5 years if your savings account pays 7%
APR. Due to inflation, the cost of the car will increase by .5% per
year over the next 5 years. (i.e. calculate the new 'F'...
1. Suppose you have an investment that costs $80,000 at the beginning of the project, and...1. Suppose you have an investment that costs $80,000 at
the beginning of the project, and it generates $30,000 a year for
four years in positive cash flows. The cost of capital is 12%. The
IRR of the project is 18.45% and the NPV is about $11,120. The IRR
model assumes that at the end of the first year you can invest the
$30,000 at ________.
a. 12.00%
b. a rate greater than the IRR
c. rate less than the cost...
If you borrow $20,000, you have to repay in equal instalments over four years. Interest Rate...If you borrow $20,000, you have to repay in equal instalments
over four years. Interest Rate is 9%. What is the interest payment
in the fourth year, 14.
a) 1499 b)1171 c)510 d)977 e)1406 f)814
You borrow $20,000 from your parents to make a house down payment at a mutually agreedupon...You borrow $20,000 from your parents to make a house down
payment at a mutually agreedupon annual interest rate of 5%, and a
payback period of 5 years (direct reduction loan). What will be
your annual, or monthly, payment amounts?
You want to buy a boat that costs today $40,000. Your plan is to save monthly amount so that you will have enough money to purchase the boat three years from now.
You want to buy a boat that costs today $40,000. Your plan is to save monthly amount so that you will have enough money to purchase the boat three years from now. The rate of inflation of boats is expected to be 3% per year for the near future, and your bank pays an interest rate of 3% per year compounded monthly. How much money you should save every month to buy the boat three years from now?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|