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

  Determine average pay

At a national seashore, the number of swimmers per day who need lifeguard assistance averages 4.1. On any day when seven or more swimmers are assisted, lifeguards receive a dollar 20 bonus for extra effort.

  Prepare a five year table to amortize the premium

Suppose the same set of facts for Stacy Corporation as in Problem 10-2 except that market rate of interest of January 1, 2008, is 8 percent & proceeds from bond issuance equal $10,803.

  Explain what would have been the amount of inventories

Explain what would have been the amount of inventories in 2011 if the 2010 turnover ratio had been maintained?

  Which kind of security would lil john need to sell

Which kind of security would Lil John need to sell to accomplish this, and how much would it have to sell

  Keep a christian perspective in finances

Visit Crown Financial Ministries and go to Media - Keep a Christian perspective in finances

  Economic benefits of the patent

On January 1, 2008, Rans Corporation purchased a patent for $595,000. The patent is being amortized over its lasting legal life of fifteen years expiring on January 1, 2023.

  Find the investment amount

Patton Corporation owns 2,500 of the 10,000 outstanding shares of Forman Company. During 2013, Forman Company earns $1,500,000 and pays cash dividends of $120,000.

  Planning for risk management

Organization must balance performance aims & associated risks. By having a plan, Organization can be better prepared for dealing with risks when they occur.

  Discuss and explain issue of related customer transactions

Discuss and explain issue of related customer transactions not being arms length transactions & risk that transactions with related customers might not be valued at same amount as they would be independent with 3rd party.

  Economic variables to identify long term financial goals

Suppose that Nike Corporation is expanding globally. One way to increase globally is to purchase shares of other firms, while other way is to open up new branches.

  Questions based on balance sheet data

Multiple Choice questions based on balance sheet data and An accounting time period that is one year in length is called and One of the accounting concepts upon which adjustments for prepayments and accruals.

  Find the investment in life insurance

You purchased a $100000 life insurance policy for single pay of $35000. If you wish to earn 9 percent on invested funds how soon must you die for the policy to have been the superior option?

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