Report of the pertinent information

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

User Account

All Pages