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 what are the main reasons that corporations may choose to

1. What are the main reasons that corporations may choose to own real estate? 2. Why is the value of corporate real estate often considered "hidden" from shareholders? 3. Why is the cost of financing with a sale-leasebac ...

In addition to the key words you should also be able to

In addition to the key words, you should also be able to define the following terms: within-subjects design repeated-measures design participant attrition history maturation instrumentation testing effects statistical re ...

1 list four important drivers of housing demand and price

1. List four important drivers of housing demand and price appreciation. 2. What are public goods? How may they be reflected in house prices? 3. When considering an investment in "distressed'' properties, what are the tw ...

Fee founders has perpetual preferred stock outstanding that

Fee founders has perpetual preferred stock outstanding that sells for $60 a share and pays a dividend of $5 at the end of each year. What is the required rate of return?

Explain the difference between path-dependent options and

Explain the difference between path-dependent options and path-independent options and give examples of each ? Give an example of a situation in which someone might wish to use a barrier option ? Explain the advantages a ...

Problem -the balance sheet of perseverance corporation on

Problem - The balance sheet of PERSEVERANCE CORPORATION on December 31, 2005, includes the following cash and receivable balances: Cash - Davao Bank   P 45,000 Currency and coins   16,000 Petty cash fund   1,000 Cash in ...

Explain the difference between a forward contract and an

Explain the difference between a forward contract and an option? What factors distinguish a forward contract from a futures contract? What do forward and futures contracts have in common? What advantages does each have o ...

Diamond inc recently paid a 110 dividend future dividends

Diamond, Inc recently paid a $1.10 dividend. Future dividends are projected at $1.14, $1.18, $1.22, and $1.25over the next four years, respectively. Beginning five years from now, the dividend is expected to increase by ...

1 what are the four important issues influencing the

1. What are the four important issues influencing the response process that are listed in this chapter? Describe each. 2. What was the goal of the International Decade for Natural Disaster Reduction? 3. How does the Unit ...

Explain why interest rate swaps are more widely used than

Explain why interest rate swaps are more widely used than currency and equity swaps? Explain how swaps are similar to but different from forward contracts ? Suppose that a party engages in a swap, but before the expirati ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen