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

  Calculate the current price of stock

If XYZ Corporation has a growth rate of 4 percent, a required rate of return (rs) of 11.5 percent, a most recent dividend paid of $5.00.

  Allocating depreciation and amortization

Jake Smith opened his Balinese new coffee shop business in downtown Boise on January first 2010. On December 31st, 2010, he sat down with his accountant to find out how his new business had done in its 1st year.

  Discuss main premise underlying the pecking order

Discuss main premise underlying the pecking order theory and also explain the "pecking order" of sources of financing?

  Retirement and estate planning

Determine when you should start to think about retirement & real estate planning and you begin taking action? Explain your answer.

  Question on treasury stock

The following items discusses the practices related to the treasury stock. Select the item that is not a correct practice.

  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

  Shows the relationship of the bond''s price

Prepare a chart that shows the relationship of the bond's price to your required return and use a range of 0% to 15% with 0.5% increments in calculating the prices.

  Calculate the current price per share

You have been given the following projections for Cali Corporation for the coming year.

  Prepare a worksheet of operations activities

Prepare a worksheet of operations activities that Harrison should inquire about this summer and if you were Harrison, what would you do

  Calculate the dollar amount of acceptable accounts

Springer manufactures wants to borrow $80,000 from a local bank using accounts receivables to secure its loan. The banks procedure is to accept as collateral accounts that are normally paid within thirty days

  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).

  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.

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