Calculate the annual end of year loan payment amount

Assignment Help Corporate Finance
Reference no: EM131515612

Assignment

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: EM131515612

Questions Cloud

Derive the firm average total cost curve equation : a) Derive the firm's average total cost curve equation. b) Do the same for the firm's average variable cost curve.
Research and analyze a tv program : For this portfolio assignment, you are required to research and analyze a TV program that ran between 1955 and 1965
Why must we take the human population size : What may result from unbridled continued growth of our population - How does the size of the human population contribute to environmental degradation?
Governor next economic conference : Imagine you have been assigned the responsibility of preparing a paper for the governor's next economic conference.
Calculate the annual end of year loan payment amount : Calculate annual end of year loan payment amount. Prepare a loan amortization schedule showing interest and principal break down of each of three loan payments.
How was roots different from these earlier television shows : How was Roots different from these earlier television shows (Good Times, Sanford & Son, etc.) in terms of the depiction of African American popular culture
What is the price elasticity of demand : Suppose Demand is given by Q = 80 - 0.5P. What is the price elasticity of demand when P = 40?
Determine the total value of assets : Determine the total value of assets. Discuss the relevance of the total value of assets to potential creditors and why this is important.
Pounds of corn with trade and specialization : If Simon sells Dave 80 pounds of green beans, then the gains from trade for Dave are ______ pounds of green beans and ______ pounds of corn.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

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