Solution-Prepare a report of the pertinent information

Prepare a report of the pertinent information

Reference no: EM13850295

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

Questions Cloud

What do we learn about willy character : Essay Title: What do we learn about Willy's character and beliefs in the opening of the play? Introduction: Introduce some of the main ideas that the play deals with e.g. capitalism and the American dream

Examine one to three advertisements that rely on humor : Examine one to three advertisements that rely on humor to make their appeal, and explain how they work. For example, do they play off an incongruity between one element of the ad and another (such as the basic message of the ad) and what we know o..

Write essay how my university education will help me : How my University education will help me achieve my career dream in the area provided and submit it prior to the first day of class.

What is the project discounted payback period : A project requires an initial cash outlay of $60,000 and has expected cash inflows of $15,000 annually for 8 years. The cost of capital is 10%. What is the project's discounted payback period? Show your work.

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

Internal revenue code sections : Can the exhusband deduct the annual payments and, if so, is the deduction For AGI for From AGI? What Internal Revenue Code Sections answer these questions?

Summerize an article about julius caesar : Summerize an article about Julius Caesar for about two paragrapghs in one page length mla format.

Facilities to accommodate the demand : Option 1: Alabama is closed but can be retooled and the company would add facilities to accommodate the demand

Equity attributable to controlling interest : The 2013 balance sheet of The New York Times Company shows average shareholders' equity attributable to controlling interest of $752,618 thousand, net operating profit after tax of $97,898 thousand, net income attributable to The New York Times Co..

User Account

All Pages

Prepare a report of the pertinent information

Reference no: EM13850295

Reference no: EM13850295

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT