Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

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.

a. find out the annual end of year loan payment amount.
b. Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.
c. Prepare a one page executive summary for the CEO, Linda Messineo, with the loan payment schedule describeing 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 find out the annual payment. Next you will use the IPMT function to find the interest portion for each of the three years.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M927925

Have any Question? 


Related Questions in Basic Finance

1 given initial investment of 500000 project life of 5

1. Given initial investment of $500,000, project life of 5 years, salvage of $50,000, CCA rate of 20%, tax rate of 40%, and required return of 15%, what is the undepreciated cost of capital at the end of Year 3? Remember ...

1 describe how structural equations modeling works2

1. Describe how structural equations modeling works. 2. Distinguish between latent variable modeling and path analysis as types of structural equations modeling.

1 compare and contrast manufacturing and geographic

1. Compare and contrast manufacturing and geographic postponement. 2. Define and illustrate cash-to-cash conversion, dwell time minimization, and cash spin. How do supply chain strategy and structure impact each? 3. Disc ...

1 is it more desirable to have the operating ratios

1. Is it more desirable to have the operating ratios increasing or decreasing for utilities and transportation companies? 2. What type of ratio is operating revenue to operating property? Will it exceed 1:1 for a utility ...

If asset as beta is greater than asset bs beta does this

If asset A's beta is greater than asset B's beta, does this mean that asset A has more risk than asset B? Explain? What is the difference between the security market line and the capital market line? How should an invest ...

1 discuss some of the advantages and disadvantages of

1. Discuss some of the advantages and disadvantages of setting up production in LCCs. Consider the benefits of market growth and the risk of an example venture. 2. Look at the information on the RDEs discussed in the tex ...

Design grammars for the following languagesa the set of all

Design grammars for the following languages: a) The set of all strings of 0s and 1s such that every 0 is immediately followed by at least one 1. ! b) The set of all strings of 0s and 1s that are palindromes; that is, the ...

One bond in forest inc has 9 years to maturity and a coupon

One bond in Forest, Inc., has 9 years to maturity and a coupon of 4.2%. The coupon is paid semiannually. If the YTM is 6%, what is the value of the bond? Marcia Food Company has a bond with 15 years to maturity and a cou ...

Raymond borrowed 300000 from loans r us company the line of

Raymond borrowed $3,000.00 from Loans R Us Company. The line of credit agreement provided for repayment of the loan in equal monthly payments of $668.76 which includes interest of 9.00 % per annum calculated on the unpai ...

What is the objective of an industry self-regulatory

What is the objective of an industry self-regulatory organization? Compare and contrast three types of futures trading costs? Compare and contrast cash settlement with physical settlement ? Identify the typical character ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro