User Account

All Pages

Prepare a report of the pertinent information

Assignment Help Finance Basics
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.

  1. Calculate the annual end of year loan payment amount.
  2. Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.
  3. 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..

Reviews

Write a Review

Finance Basics Questions & Answers

  Compare linear regression to the moving averages

Compare linear regression to the moving averages and smoothing techniques used in. Why is linear regression more appropriate for long-range forecasts?

  How much will mr. robbins pay for the bond

If the prevailing annualized yield on other bonds with similar characteristics is 6 percent, how much will Mr. Robbins pay for the bond? A) $1,000.00 B) $1,147.20 C) $856.80 D) none of these

  Calculating rate of return of investment using financial

calculating the rate of return of investment using financial leverage. suppose shaan invested just 10000 of his own

  A building is priced at 125000 if a down payment of 25000

a building is priced at 125000. if a down payment of 25000 is made and a payment of 1000 every month thereafter is

  Vulnerable corporation an all-equity corporation has 10000

vulnerable corporation an all-equity corporation has 10000 shares priced at 5 per share. the firm is considering

  You are the client manager of sensible essentials using the

with the assistance of sensible essentials the operations management team now understands the cost implications

  The newly established operations management team decided to

the newly established operations management team decided to seek outside assistance in developing a long-term operating

  Identify the five states with the highest and lowest incomes

Explain why it is important for marketers to be aware of ethnic growth rates by going to the Projections link and viewing the projected growth rates for 2010.

  Compute the annual percentage rate of interest

Suppose you decide to buy a building for $30,000 by paying $5,000 down and suppose a mortgage of $25,000. The bank offers you a fifteen year mortgage requiring annual end of year payments of $3,188 each.

  You and a few friends have just graduated from charles

picture this you and a few friends have just graduated from charles sturt university and see in the newspaper the

  What will be the portfolio expected rate of return

What do you think will happen to the portfolio's expected rate of return and standard deviation if the portfolio contained 75 percent of Project B?

  Provide a specific example of a company that took an action

provide a specific example of a company that took an action that might have increased short run profits but had the

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd