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

  What is the stock price for omega technology

Suppose Alpha Industries and Omega Technology have identical assets that generate identical cash flows. Alpha Industries is an all-equity firm, with 10 million shares outstanding that trade for a price of $22 per share. Omega Technology has 20 millio..

  Shown is a probability distribution for the random variable

shown is a probability distribution for the random variable x.x fx3 ...................0.256 ....................0.509

  Question regarding the volatility of stocks

You decide to show Alice Cartwright how beta affects the volatility of stocks. You need to go out and find 5 stocks in which you think Alice might have investment interest.

  Computation of payback period

Computation of Payback period and what is the payback period for a $20,000 project expected to return $6,000 for the first two years and $3,000

  What factors contribute to complexity of the revenue cycle

What factors contribute to the complexity of the revenue cycle in health care? What are the six stages of the revenue cycle?

  Does create potential corporate issues

Does this create potential corporate issues?

  Should the compensation consist of a dollar salary

If you were also a vice president of Company X, might your actions be different than if you were the CEO of some other company?

  Determine the factors that the manager of a financial

question 1asuggest which factors have the most significant impact on a financial-service institutions decision

  Important part of developing and implementing a strategy

Understanding supply chain and how the consumer can play a critical role in the supply chain is an important part of developing and implementing a strategy. There are many products and services today where the target customer is part of the supply..

  Determination of projects npv

Epsilon Company is evaluating an expansion of its business. The cash-flow forecasts for the project are as follows:

  What is the reason for the long run equilibrium of a firm

What is the reason for the long run equilibrium of a firm in monopolistic competition to be associated with zero profit?

  What nominal interest rate would you require from the bank

assume you just deposited 1000 into a bank account. the current real interest rate is 2 and inflation is expected to

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