Determine the annual end of year loan payment amount

Assignment Help Corporate Finance
Reference no: EM1347226

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.

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

Questions Cloud

Explain trade-off and pecking-order theories : Explain how can you anticipate the indebtedness of the company to evolve in the future if the reality is based on trade-off theory
Creating modular program to enter monthly costs : Create a modular program which asks the user to enter monthly costs for expenses given incurred from operating his or her automobile.
What maximum mass can be lifted at the output piston : A soccer ball of diameter 30 cm rolls without slipping at a linear speed of 2.7 m/s. Through how various  revolutions has the soccer ball turned as it moves a linear distance of 16 m.
What would happens to the level of gross debt : what happens to the amount of debt held by the public. What would happens to the level of gross debt.
Determine the annual end of year loan payment amount : Messineo LLC purchased 15,000 dollar at a 14 percent yearly rate of interest to be repaid over three years. The loan is amortized into 3 equal yearly end of year payments. So determine the annual end of year loan payment value.
Computer system and behavior : Computer system, behavior, ethnic diversity, and motivation - One of the issues in this solution refers to an employee who is reluctant to shift to new way of doing things.
What is full costing : What is full costing? Define and compare job order costing and activity-based costing.
Explain what should be the production level if fixed costs : Explain what should be the production level if fixed costs rose to $70,000 per month. what should be the production level if the producer operates in a monopolistic competitive market where the price of software at each possible quantity.
Determine cost of internal equity capital : The common stock for Grapevine Plumbing Corporation currently sells for 40 dollar per share. If a new issue is sold, flotation cost is estimated to be 7 dollar per share. Determine the cost of internal equity capital & external equity capital.

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