(Answered) Critical thinking view grade info grade na executive

Accounting

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.

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M91240395
Price:- $30

Verified Expert

Priced at $60 Now at $30, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question - dan bought a hotel for 2600000 in january 2012

Question - Dan bought a hotel for $2,600,000 in January 2012. In May 2016, he died and left the hotel to Ed. While Dan owned the hotel, he deducted $289,000 of cost recovery. The fair market value in May 2016 was $2,800, ...

Question - income computation for a manufacturing firmthe

Question - Income Computation for a Manufacturing Firm The following data relate to GenMet, a U.S. based consumer goods manufacturing firm, for the fiscal year ending October 31, 2013. Reported amounts are in millions of ...

Question - for this assessment you will need to complete a

Question - For this assessment, you will need to complete a Form 1040, Form 4562, Schedule C, and Schedule SE and submit them as file uploads. The PDF forms are available here and in the assessment instructions. Jayne Sm ...

Question - on january 1 2017 palka inc acquired 70 percent

Question - On January 1, 2017, Palka, Inc., acquired 70 percent of the outstanding shares of Sellinger Company for $1,479,800 in cash. The price paid was proportionate to Sellinger's total fair value, although at the acq ...

Question - in 2002 the executives at telecommunications

Question - In 2002, the executives at telecommunications giant WorldCom perpetrated accounting fraud that led to the largest bankruptcy in US history. The company improperly booked about $4 billion as capital expenditure ...

Question - x companys profit equation next year is expected

Question - X Company's profit equation next year is expected to be 0.47R-$12,900, where R is total revenue. Assuming a tax rate of 36%, what must next year's revenue be in order for X Company to earn after-tax profits of ...

Question - research current literature incorporate

Question - Research current literature, incorporate professional experiences from your organization, and prepare a paper of 3-5 pages on the budgeting process and its impact on the strategic plan of the organization. It ...

Question - the following information relates to nebula

Question - The following information relates to Nebula, Inc. Sales Revenue $240,000 Cost of Goods Sold 160,000 Interest Revenue 10,000 Operating Expenses 40,000 Sales Discounts 20,000 Sales Returns and Allowances 7,000 C ...

Question -how susceptible are you to undue influence to

Question - How susceptible are you to undue influence to alter records of transactions? Do you have the strength of your convictions to stand up to a rich and powerful CEO who orders you to change the records?

Question - the will of the decedent established a trust for

Question - The will of the decedent established a trust for the benefit of his wife and two sons. The trust states that the trustee shall pay to the widow $25,000 a year and $12,500 a year to each of his two sons. There ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert