Calculate the annual end of year loan payment amount

Assignment Help Financial Management

Reference no: EM13980921

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. 1.Calculate the annual end of year loan payment amount. 2. Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments. 3.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: EM13980921

Questions Cloud

After-tax cash flows for two mutually exclusive projects : 1. Following are the estimated after-tax cash flows for two mutually exclusive projects:

Compute timmers ending inventory balance : In 2015, Timmers, Inc. (a retail clothing company) sold 222,000 units of its product at an average price of $50.00 per unit. The company reported estimated returns and allowances in 2015 of 2.0 percent of gross revenue. Referring back to the previous..

Expected rate of return and volatility of the portfolio : The stocks have a correlation of 0.9. What is the expected rate of return and volatility of the portfolio?

The net process on the sale of the asset would be : An asset cost $10,000 and can be sold for $6,000. The book value of the asset is $4,000 and the tax rate is 35%. The net process on the sale of the asset would be:

Calculate the annual end of year loan payment amount : 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 shor..

How was the intron structure of these genes determined : Again looking at your plot from problem 5, what organism provides the best evidence from conservation for or against the specific human gene structure model?

Determined the common stock-accounts payable : Determined the common stock for Bertinelli Corp. based on the following information: cash = $290,000; patents and copyrights = $670,000; accounts payable = $470,000; accounts receivable = $159,000; tangible net fixed assets = $4,200,000; inventory = ..

Transaction deposits on its balance sheet : Patriotic Bank currently has $800 million in transaction deposits on its balance sheet. The current reserve requirement is 10 percent, but the Federal Reserve is decreasing this requirement to 8 percent. Present the balance sheet (before and after ch..

Find the capitalized cost of a present cost : Determine which plan is more economical on the basis of a present worth analysis over a 10-year period at an interest rate of 10% per year - Find the capitalized cost of a present cost of $300,000, annual costs of $35,000, and periodic costs every ..

User Account

All Pages