Prepare a loan amortization schedule showing the interest

Assignment Help Financial Management

Reference no: EM131492614

Messineo LLC borrowed $15,000 at a 14% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal annual end of year payments. As the CFO of Messineo, LLC you must prepare a report of the pertinent information in a short summary for the CEO.

Calculate the annual end of year loan payment amount.

Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.

Prepare a one page executive summary for the CEO, Linda Messineo,with the loan payment schedule explaining why the interest portion of each payment declines with the passage of time.

Also, be sure to remind her that the interest portion of the loan payment is tax deductible. You should include your spreadsheet as an appendix to your executive summary to prove your figures in the loan payment schedule.

Hint: Using a spreadsheet, you will start with the PMT function to calculate the annual payment. Next you will use the IPMT function to find the interest portion for each of the three years.

Reference no: EM131492614

Questions Cloud

A goal of an equity analysis is to find securities : A goal of an equity analysis is to find securities

Firms dividends are expected to grow at rate : This firm's dividends are expected to grow at a rate of 6% per year. Investors' required rate of return for this stock is 16%. How much is this stock worth?

How much will mike’s balloon payment be in eight years : Mike Bayles has just arranged to purchase $490,000 vacation home in Bahamas with 25 percent down payment. How much will Mike’s balloon payment be in eight years

Compare the benefits of the ais tool balance scorecard : Compare the benefits of the AIS tool balance scorecard to that of graphs for financial reporting purposes.

Prepare a loan amortization schedule showing the interest : Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.

Calculate how much money a prospective homeowner : Calculate how much money a prospective homeowner would need for closing costs on a house that costs ?$179,900.

Accrued interest due to seller from the buyer at settlement : Calculate the accrued interest due to the seller from the buyer at settlement. Calculate the dirty price of this transaction.

Working capital management : "Working Capital Management"-Examine the key reasons why a business may not want to hold too much or too little working capital.

Calculate how much money a prospective homeowner : Calculate how much money a prospective homeowner would need for closing costs on a house that costs $105,000.

User Account

All Pages