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

In what form can a depository institution hold its required

In what form can a depository institution hold its required and excess reserves? What are the possible uses of currency outside the Fed?

The float increases unexpectedlywill the fed typically

The float increases unexpectedly. Will the Fed typically respond with outright purchases or temporary purchases?

1 the price of ervin corp stock will either be 60 or 80 at

1) The price of Ervin Corp. stock will either be $60 or $80 at the end of the year. Call options are available with one year until expiration. T-bills currently yield 3.26 %. Suppose the current price of Ervin stock is $ ...

In 1803 the us doubled in size with the louisiana purchase

In 1803, the U.S. doubled in size with the Louisiana Purchase. That well-known real estatemogul Napoleon Bonaparte sold us 827,000 square miles (529,280,000 acres-there are 640 acresin a square mile). We paid $15 million ...

A stock is currently selling for 39 per share a call option

A stock is currently selling for $39 per share. A call option with an exercise price of $45 sells for $3.47 and expires in three months. If the risk-free rate of interest is 4.6 % per year, compounded continuously, what ...

What are nondeposit liabilities give some exampleswhat are

What are nondeposit liabilities? Give some examples. What are negotiable CDs? How do nondeposit liabilities differ from negotiable CDs? What are retail sweep accounts? What are credit derivatives?

Bull articulation of the statement of cash flows with other

• Articulation of the Statement of Cash Flows with Other Financial Statements . Describe how the statement of cash flows is linked to each of the other financial statements (income statement and balance sheet). Also revi ...

Lasa npv sensitivity risk bias and ethics in capital

LASA: NPV, Sensitivity, Risk, Bias and Ethics in Capital Budgeting Investment projects should never be selected through purely mechanical processes. Managers should ask questions about the positive net present value (NPV ...

Assignment instructions-1 enter your student class number

Assignment Instructions- 1. Enter your student class number in cell A1 under the "Firm's debt tab" 2. Look at that "Spreads&Treasuries" tab to find your rating. Each of your debts has the same rating. Enter the rating le ...

I need your help with the below three assignment no need

I need your help with the below three assignment. No need for "Executive Summary" just start with introduction, please. Assignment 1: Module 01 - Introduction and Framework for Sustainability Which of the nine principles ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate