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.

Reviews

Write a Review

Financial Management Questions & Answers

  What will the price of this bond

what will the price of this bond be in 25 years?

  Does gallo face currency risk

Gallo is a large wine producer in the US. It gets all its grapes in California and sells its wines only in the US. Does Gallo face currency translation exposure? Explain. Does Gallo face currency risk? why and how?

  Calculate the value of your estate periodically

Why is it important to calculate the value of your estate periodically?- Beyond the will, what does estate planning involve?

  Compute the discounted payback statistic for project

Compute the discounted payback statistic for Project D if the appropriate cost of capital is 10 percent and the maximum allowable discounted payback is four years.

  Rules in deducting costs associated with donated services

What are the rules in deducting costs associated with donated services? What are the benefit received rules concerning charitable contributions?

  Purchased a new warehouse

You have just purchased a new warehouse. To finance the purchase, you’ve arranged for a 35-year mortgage loan for 85 percent of the $3,500,000 purchase price. The monthly payment on this loan will be $17,600. What is the APR on this loan?

  What will dividend yield and capital gains yield be in year

Suppose a company has net income of $1,000,000 and a plowback ratio of 40%. there are 50,000 shares of stock outstanding. the company plans to increase dividends by 22% each year for the next 2 years and then apply a 2.25% growth rate to dividends ea..

  Considering two savings options

You are considering two savings options. Both options offer a 4% rate of return. The first option is to save $1,200, $1,500, and $2,000 a year over the next three years, respectively. The other option is to save one lump sum amount today. If you want..

  Two most popular capital budgeting methods

Graham and Harvey (2001) found that ___ and ___ were the two most popular capital budgeting methods. Select one: a. Internal rate of return; payback period b. Internal rate of return; net present value c. Net present value; payback period d. Modified..

  What rate of return did ramon earn on his investment

About a year ago, Ramon Navarrete bought some shares in the Saphire Lake Mutual Fund. what rate of return did Ramon earn on his investment?

  Appropriate election to treat cutting as sale or exchange

A corporation owns many acres of timber, The corporation made the appropriate election to treat the cutting as a sale or exchange.

  Cash flows in sophisticated capital budgeting techniques

The rate used to discount the firm's cash flows in sophisticated capital budgeting techniques is called the:

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd