Messineo llc borrowed 15000 at a 14 annual rate of interest, Ask an Expert

Finance

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.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M927925

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Summit record company is negotiating with two banks for a

Summit Record Company is negotiating with two banks for a $139,000 loan. Fidelity Bank requires a compensating balance of 14 percent, discounts the loan, and wants to be paid back in four quarterly payments. Southwest Ba ...

This morning you purchased one share of stock for 26 the

This morning, you purchased one share of stock for $26. The stock pays $.32 per share each quarter as a dividend. What must the stock price be 1 year from now if you want to earn a total return of 16 percent for the year ...

The transactions of the lou corporation were as followsmay

The transactions of The Lou Corporation were as follows. May 4 Paid $1,700 due for supplies previously purchased on account. 7 Performed advisory services on account for $7,500. 8 Purchased supplies for $850 on account. ...

You want to borrow 65000 from your local bank to buy a new

You want to borrow $65,000 from your local bank to buy a new sailboat. You can afford to make monthly payments of $1,320, but no more. Assuming monthly compounding, what is the highest APR you can afford on a 60-month lo ...

If a firm has retained earnings of 31 million a common

If a firm has retained earnings of $3.1 million, a common shares account of $5.1 million, and additional paid-in capital of $10.2 million, how would these accounts change in response to a 10 percent stock dividend? Assum ...

Explain the systematic risk principle and how it relates to

Explain the systematic risk principle and how it relates to beta. according to the below message SYSTEMATIC RISK AND BETA The question that we now begin to address is this: What determines the size of the risk premium on ...

Why does the binomial option pricing formula discount the

Why does the binomial option pricing formula discount the expected cash flows using the risk-free rate?

Assume that real risk-free rate r 100 the maturity risk

Assume that real risk-free rate (r*) = 1.00%; the maturity risk premium is found as MRP = 0.20%×(t - 1), where t = years to maturity; the default risk premium for AT&T bonds is found as DRP = 0.07%×(t - 1); the liquidity ...

A firm is considering a project that has the following

A firm is considering a project that has the following estimated cashflows: Increased sales to business of $100,000 for the next six years (starting in one year's time) Increased costs of $30,000 for the next six years ( ...

What is marketing discipline what is most peoples

What is marketing discipline? What is most people's perception of marketing discipline? Name an organization that has done a great job marketing. What did they do to make you feel this way?

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

Recent Questions

Ask Basic Finance Expert