Report of the pertinent information

Assignment Help Finance Basics
Reference no: EM13754108

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

Questions Cloud

Project on networking service request : Resources: Service requests SR-lf-003, SR-ht-011, and SR-kf-015; and the Lafluer Trading Company, Huffman Trucking, and Kudler Fine Foods Virtual Organizations. Review this entire document. Choose one of the SR-lf-003, SR-ht-011, or SR-kf-015 serv..
Distinguish between extrinsic and intrinsic rewards : Distinguish between extrinsic and intrinsic rewards and explain and provide examples for the four building blocks of intrinsic rewards and motivation. How does your organization motivate and reward their employees? Please provide examples to support ..
Dividends are expecting to continue growing at a constant : Burp-Cola just finished making an annual dividend payment of $2.- per share on its common stock. Its common stock dividend has been growing at an annual rate of 10% . Kelly Scott requires a 16% on this stock. What intrinsic value should Kelly place o..
Calculate the npv of investment : The farm is expected to produce revenue of $2.00 million each year, and annual cash flow from operations equals $1.80 million. The marginal tax rate is 35 percent, and the appropriate discount rate is 10 percent. Calculate the NPV of this investme..
Report of the pertinent information : 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 s..
Management estimates the revenues and costs : Hytek Company bottles and distributes Livit, a diet soft drink. The beverage is sold for 50 cents per 16-ounce bottle to retailers, who charge customers 75 cents per bottle. For the year 2012, management estimates the following revenues and costs.
Identify a company that provides diversity training : Identify a company that provides diversity training for its employees. Obtain information about the philosophy behind the diversity training program and what it generally entails. A good starting place might be "The 100 Best Companies to Work For" or..
Investment and portfolio analysis : Investments has superior stock picking skills. What your boss would like you to do is to come up with a recommendation to buy, sell or hold the stock of Ryman HealthCare. This is a complex task as it requires you to combine many of the skills you ..
Describe two control techniques to prevent this fraud scheme : John Smith worked in the stockyard of a large building supply company. One day he unexpectedly left for California, never to return. His foreman seized the opportunity to continue to submit time cards for John to the payroll department. Each week, as..

Reviews

Write a Review

 

Finance Basics Questions & Answers

  What is the yield to call

Interest rates have declined since it was issued, and it is now selling at 114.12% of par, or $1,141.2

  Russos gas distributor inc wants to determine the required

russos gas distributor inc. wants to determine the required return on a stock with a beta coefficient of 0.5. assuming

  Assuming the following ratios are constantm what is the

assuming the following ratios are constantm what is the sustainable growth rate?total asset turnover 1.90profit margin

  A firm has earnings of 230 this year grows by about 6 each

a firm has earnings of 230 this year grows by about 6 each year and has a price earnings ratio of 40. what would its

  The firms reported earnings are 300000 after the issuance

expected price. wolinsky corporation is considering a public issuance of its securities. the average pe ratio in the

  What information can a user of financial statements obtain

what information can a user of financial statements obtain from the statement of cash

  As the increased number of wealthy family more and more

as the increased number of wealthy family more and more people are seeking advise on how to manage their wealth to make

  Find 3 different financial statements that have varying

find 3 different financial statements that have varying capital structures.write a paragraph about each that explains

  Investigate benefits-disadvantages of expanding

You are a business owner firm that manufactures a specialized product in the United States. While developing a 5-year strategic growth plan, you have decided to investigate the benefits and disadvantages of expanding internationally. Research the ..

  What is the project payback period

What is the project payback period if the initial cost is $1,575? (Enter 0 if the project never pays back. Round your answer to 2 decimal places.

  What is joint probability distribution for saving per year

what is the joint probability distribution for saving per year and useful life?

  A two-year bond pays a coupon rate of 10 percent and a face

a two-year bond pays a coupon rate of 10 percent and a face value of 1000. in other words the bond pays interest of 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