The pertinent information in a short summary for the ceo

Assignment Help Accounting Basics
Reference no: EM13700962

Critical Thinking
View Grade Info
Grade: N/A

Executive Summary (115 Points)

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

Questions Cloud

England productions performs london : England Productions performs London shows. The average show sells 1,300 tickets at $60 per ticket. There are 150 shows per year. No additional shows can be held as the theater is also used by other production companies. The average sh..
Evaluate the individual tax brackets in the federal tax : Congress has asked you to evaluate the individual tax brackets in the federal tax code and make several recommendations to improve the fairness of the tax brackets. Using the Internet and Strayer Library, research the current federal tax b..
Change in owners'' equity for the year : Prepare the retained earning portion of a statement of change in owners' equity for the year ended December 31, 2010.
Critically analyse the argument that social workers : Critically analyse the argument that social workers have an ethical responsibility to engage in public debates that affect their clients regardless of the interests of the organisation for which they work.
The pertinent information in a short summary for the ceo : 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 ..
Read the footnote in appendix a referring to home depot : Read the footnote in Appendix A referring to Home Depot 's decision to close all of its remaining big box stores in China. Write a short paragraph identifying the incremental, sunk, and opportunity costs associated with this decision. Assume that ..
Bank reconciliation and entries : The cash account for Remedy Medical Co. at April 30, 2014, indicated a balance of $18,885. The bank statement indicated a balance of $23,775 on April 30, 2014. Comparing the bank statement and the accompanying canceled checks and memos with th..
Describe the significance of case review : Describe the significance of case review, report writing and documentation, and client participation during the helping process.
Explain the effect on cash received by the borrower : Explain the effect on Cash Received by the borrower and Interest Calculations when payments are made and interest expense recognized each period if

Reviews

Write a Review

Accounting Basics Questions & Answers

  Improve the quality of the product his company manufactures

Bill wants to purchase a machine to help improve the quality of the product his company manufactures

  Why would a manufacturing and a retail company have

why would a manufacturing and a retail company have different accounting cycles? would you expect the steps of the

  Compton company reported the following information on its

compton company reported the following information on its comparative financial statements sales revenue 24.0 million

  The florida corp closes its books once a year on dec 31 on

the florida corp. closes its books once a year on dec. 31. on aug. 12 2011 floridas merchandise inventory account has a

  Process costing system basics

Which of the following products is more likely to be costed and controlled under a Job Order Costing system, rather than a Process Costing system?

  Which ratio indicates the percentage of each sales dollar

which ratio indicates the percentage of each sales dollar that is available to cover fixed costs and to provide a

  Agricultural commodities are known to have a

agricultural commodities are known to have a price-inelastic demand and to be necessities. how can this

  During 2012 and 2013 supplies inc drove the truck 15000 and

during 2012 and 2013 supplies inc. drove the truck 15000 and 22000 miles respectively to deliver merchandise to its

  After the amount due on a sale of 28000 term 210 neom is

after the amount due on a sale of 28000 term 210 neom is received from a customer within the discount period the seller

  Prepare my return taking my son & daughter as exemptions

Prepare my return taking my son & daughter as exemptions.

  Prepare the investments section of the balance sheet

Common stock of Ely Inc. (30% ownership), cost $210,000, equity $270,000. Prepare the investments section of the balance sheet.

  What is the receivables turnover for sampson

The following information pertains to Sampson Company. Assume that all balance sheet amounts represent both average and ending balance figures. Assume that all sales were on credit.

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