Question

In: Finance

A loan of $3,200 is obtained at 8.4% payable monthly and is due in six years....

A loan of $3,200 is obtained at 8.4% payable monthly and is due in six years. To accumulate the principal the borrower will make monthly deposits into a sinking fund which earns 7.2% interest compounded monthly. Determine the total periodic payment. IF the debt had been amortized with payments equal in size to the total periodic payment, what would be the effective interest rate to the nears 0.01%?

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -


Related Solutions

The loan is for $150,000 with a rate of 6% for 30 years payable monthly. Calculate...
The loan is for $150,000 with a rate of 6% for 30 years payable monthly. Calculate the Monthly Payment (MP): Do a monthly Amortization Table for 4 months using the MP: Calculate the Loan Balance (LB) using the formula approach at the end of 4 months.
A loan amount of L is amortized over six years with monthly payments (at the end...
A loan amount of L is amortized over six years with monthly payments (at the end of each month) at a nominal interest rate of i(12) compounded monthly. The first payment is 500 and is to be paid one month from the date of the loan. Each subsequent payment will be 1% larger than the prior payment. (a) If i(12) = 9%, find the principal repaid in the 25th payment. (b) If i(12) = 12%, find the amount of loan...
Refinance decision: The original loan is for $150,000 with terms 6%, 30 years payable monthly. The...
Refinance decision: The original loan is for $150,000 with terms 6%, 30 years payable monthly. The elapsed time on the original loan is 5 years. The new loan rate is 3.6% which will be held 7 years. The cost of refinancing is $3,000. The opportunity cost is 9%. A. Prepare a table that calculates the change in monthly payment and change in Loan Balance numbers: B. Do the Present Value Analysis:
A 25 year home loan of $125000 at 7.25% compounded monthly is obtained. a.  Find the monthly...
A 25 year home loan of $125000 at 7.25% compounded monthly is obtained. a.  Find the monthly payments rounded up to the next cent. b.  State the total amount of interest paid on the loan assuming that it is kept for 25 years and all payments are the same.
A couple who borrow $80,000 for 30 years at 8.4%, compounded monthly, must make monthly payments...
A couple who borrow $80,000 for 30 years at 8.4%, compounded monthly, must make monthly payments of $609.47. (a) Find their unpaid balance after 1 year. (Round your answers to the nearest cent.) $ (b) During that first year, how much do they pay towards the principle? (Round your answer to the nearest cent.) $ During that first year, what are their total payments? (Round your answer to the nearest cent.) $ During that first year, how much interest do...
A couple who borrow $80,000 for 30 years at 8.4%, compounded monthly, must make monthly payments...
A couple who borrow $80,000 for 30 years at 8.4%, compounded monthly, must make monthly payments of $609.47. (a) Find their unpaid balance after 1 year. (Round your answers to the nearest cent.) (b) During that first year, how much do they pay towards the principle? (Round your answer to the nearest cent.) During that first year, what are their total payments? (Round your answer to the nearest cent.) $ During that first year, how much interest do they pay?...
A couple who borrow $50,000 for 15 years at 8.4%, compounded monthly, must make monthly payments...
A couple who borrow $50,000 for 15 years at 8.4%, compounded monthly, must make monthly payments of $489.44. (Round your answers to the nearest cent.) (a) Find their unpaid balance after 1 year. $ (b) During that first year, how much interest do they pay? $
An investment project costs $16,700 and has annual cash flows of $3,200 for six years. a....
An investment project costs $16,700 and has annual cash flows of $3,200 for six years. a. What is the discounted payback period if the discount rate is zero percent? b. What is the discounted payback period if the discount rate is 3 percent? c. What is the discounted payback period if the discount rate is 22 percent?
Two payments of $16,000 and $3,200 are due in 1 year and 2 years, respectively. Calculate...
Two payments of $16,000 and $3,200 are due in 1 year and 2 years, respectively. Calculate the two equal payments that would replace these payments, made in 6 months and in 4 years if money is worth 5% compounded quarterly.
Cloverdale Nurseries obtained a $77,000 loan at 9.2% compounded monthly to build an additional greenhouse. Monthly...
Cloverdale Nurseries obtained a $77,000 loan at 9.2% compounded monthly to build an additional greenhouse. Monthly payments were calculated to amortize the loan over six years. Construct a partial amortization schedule showing details of the first two payments, Payments 40 and 41, and the last two payments. (Do not round intermediate calculations and round your answers to 2 decimal places. Leave no cells blank - be certain to enter "0" wherever required.) Payment number Payment Interest portion Principal portion Principal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT