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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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