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

  Find annual interest rate n 30 years quarterly payments

find annual interest raten 30 years quarterly paymentsinterest rate compounded quarterlypv 1200000pmt -90000fv

  Identify a global organization with a multinational presence

Identify a global organization with a multinational presence. Identify and research a cultural issue that affects this organization's interactions outside the United States.

  How does berkshire partners create value does carters fit

case berkshire partners bidding for cartersquestionsbull how does berkshire partners create value?bull does carters fit

  The imf and world bank are the worldrsquos two leading

1 international financethe imf and world bank are the worldrsquos two leading lending institutions but as acemoglu and

  Heavy concentration in mortgages

Savings institutions are exposed to credit risk as a result of their heavy concentration in mortgages, mortgage-backed securities, and other securities. They attempt to diversify their investments to reduce credit risk. Savings institutions ar..

  What is the firms cost of preferred stock

The 8 percent preferred stock of Home Town Brewers is selling for $47 a share. What is the firm's cost of preferred stock if the tax rate is 0.44 and the par value per share is $120?

  An example of how to calculate the tax liability using the

another client ms. dunham has asked you to help her understand how her tax is computed. you need to provide ms. dunham

  Assuming the appropriate interest rate for discounting is

will smith will receive 80000 on december 31 2017 5 years from now from a trust fund established by his father.

  The exercise price on one of the first link investment

the exercise price on one of the first link investment corporations call option us 15 its exercise value is 22 and its

  What is the add-on interest rate for the bank loan

By how much would Jack lower the APR on the bank loan if he opened an account to avoid the credit check and application fees?

  Compound annual rate of return

Suppose you are 25 years old and inherit $65,000 from your grandmother. If you wish to purchase a $100,000 yacht to celebrate your 30th birthday,

  Construct an extended du pont equation and compare the

a firm has been experiencing low profitability in recent years. perform an analysis of the firms financial position

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