Calculate the annual end of year loan payment amount

Reference no: EM13753206

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

Questions Cloud

What is the probability that mona was justifiably dropped : Any athlete who fails the Enormous State University's women's soccer fitness test is automatically dropped from the team. Last year, Mona Header failed the test, but claimed that this was due to the early hour. (The fitness test is traditionally give..

Describ impact of civil rights movement on masses of blacks : Explain the Impact of the civil rights movement on the masses of blacks in the south between 1954 and 1965.

Similarities of common stocks and bonds : Contrast the differences/similarities of common stocks and bonds. Explain how they would be used in the corporate environment.

According to a study released suggesting a link between too : Eight hours of nightly sleep is not the health panacea you were brought up to believe, according to a study released suggesting a link between too much slumber and a shorter life span.Sleep experts immediately sought to discredit the conclusions and ..

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

Describe the different organizational structures : Describe the different organizational structures as it relates to project management (i.e., functional, project-based, matrix)

Examine the shift from postmodernism back to realism : Examine and explain Postmodernism encorporating at least some of our authors as reference. Examine the shift from Postmodernism back to Realism.

Creating a performance grading : To correct this situation, you will begin by creating a performance grading form that will be used to assess the front-line supervisor's performance. Create a form that includes areas the supervisors should be graded on and the relative weight or ..

Determine the latest book value per share : Using the resources at your campus or public library or on the Internet, elect any 3 common stocks you like and determine the latest book value per share, earnings per share, dividend payout ratio, and dividend yield for each.

User Account

All Pages