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

  Develop a process map using the strategic planning process

Develop a process map using the strategic Planning Process as your guideline. Make sure you include the following All of the 6 steps of the Strategic Planning Process (Environmental Assessment, Strategic Objectives, Action Plan).

  Pro forma analysis of cash flow

Revenue stream and diversify their business GEI expanded into the higher margin business of consumer products - discuss a number of proposals that looked promising. In order to smooth their revenue stream and diversify their business GEI expanded in..

  Long-term financing neededat year-end 2012 total assets for

long-term financing neededat year-end 2012 total assets for ambrose inc. were 1.8 million and accounts payable were

  Adjust the applicable purchase prices

If you are in a State or Territory that only offers a FHOG on new and not established homes you will have to choose that option for a case study - You are required to have a third party to observe this role play in a simulated environment.

  Cost of capital airjet best parts inc is now considering

cost of capital airjet best parts inc. is now considering that the appropriate discount rate for the new machine should

  1 a very small countrys gross domestic product is 12

1. a very small countrys gross domestic product is 12 million.a. if government expenditures amount to 7.5 million and

  Kolby corp is comparing two different capital structures

kolby corp. is comparing two different capital structures. plan i would result in 900 shares of stock and 65700 in

  Why it is not necessary to subtract the interest payments

Compute the cost of capital for the project. Compute the NPV for the project. Explain why it is not necessary to subtract the interest payments and the dividend payments and appreciation from the inflow of $40,000 in carrying out this computati..

  A united states company x has contracted to provide a

a united states company x has contracted to provide a service to a european company z european company uses the euro

  Analyze the organizations statement of cash flows

Analyze the organization's statement of cash flows. Explain the format that the organization utilizes, including any unique areas of emphasis that differ from-GAAP accounting format.

  Was change consistent with classical theory of asset prices

The text Web site links to bloomberg.com, which provides daily data on the Dow Jones stock index. - Find a day within the last year when the index rose or fell by at least 2 percent.

  Q1 you are a buyer for a battery company and are

q1. you are a buyer for a battery company and are investigating the purchase of lithium from an african company for 100

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