Payments based on amortization schedule

Assignment Help Financial Management

Reference no: EM132055972

Your firm has taken out a $ 502,000 loan with 8.9 % APR (compounded monthly) for some commercial property. As is common in commercial real estate, the loan is a 5 -year loan based on a 15 -year amortization. This means that your loan payments will be calculated as if you will take 15 years to pay off the loan, but you actually must do so in 5 years. To do this, you will make 59 equal payments based on the 15-year amortization schedule and then make a final 60th payment to pay the remaining balance.? (Note: Be careful not to round any intermediate steps less than six decimal places.)

a. What will your monthly payments be?

b. What will your final payment be?

PLEASE POST ANSWER WITH EXCEL and Steps clearly labled.

Reference no: EM132055972

Questions Cloud

Average of price minus variable cost for all belts combined : The J&J Company has three product lines of belts -- A, B, and C. calculate the weighted average of the price minus variable cost for all belts combined.

What are the net operating cash flows during years one-two. : What is the initial investment outlay, that is, the Year 0 project cash flow? What are the net operating cash flows during Years 1, 2, and 3?

Dividend discount and residual income valuation models : Critically discuss the merits and limitations of the Discounted Cash Flow, Dividend Discount and Residual Income valuation models,

Sales per year for overhauling to be preferred alternative : What should be your "sales per year" for overhauling to be the preferred alternative?

Payments based on amortization schedule : You will make 59 equal payments based on the 15-year amortization schedule and then make a final 60th payment to pay the remaining balance.?

Thinking of building chemical processing plant : GDebi Enterprises is thinking of building a chemical processing plant to produce 4-hydroxy-3-methoxybenzaldehyde.

What is the amount of next dividend : One-third of the return on this stock is derived from dividends and the other two-thirds is derived from capital gains. What is the amount of the next dividend?

Sales outstanding on its cash conversion cycle : Winston Inc. is trying to determine the effect of its inventory turnover ratio and days sales outstanding on its cash conversion cycle.

Calculate annual return on the mutual fund over two-year : Suppose an individual invests $50,000 in a load mutual fund for two years. calculate the annual return on the mutual fund over the two-year investment period.

User Account

All Pages