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 is it true that most of the findings of behavioral

1. Is it true that most of the findings of behavioral research are just common sense? 2. Why is the philosophy of science important to behavioral researchers? 3. Why must hypotheses be falsifiable?

1 what is meant by a real option2 what is meant by the term

1. What is meant by a "real option"? 2. What is meant by the term overage for retail space? 3. How does the use of scenarios differ from sensitivity analysis?

Consider a two-period two-state world let the current stock

Consider a two-period, two-state world. Let the current stock price be $35 and the risk-free rate be 5%. In each period, the stock price can either go up by 10% or down by 10%. A call option expiring at the end of the se ...

Visit the website for your state homeland security office

Visit the website for your state homeland security office. Where in government is this office? What grants and other assistance does it provide to local governments and citizens of the state? Is this office colocated wit ...

1 what are the criteria that investors should consider in

1. What are the criteria that investors should consider in determining whether to invest in load funds or no-load mutual funds? 2. List the major differences between a financial planner and broker. 3. What are the advant ...

Ethical dilemma- rita is the office manager of a

Ethical Dilemma:- Rita is the office manager of a three-doctor practice. Her brother, Juan, a recent college graduate, recently started working for a large insurance company that specializes in health insurance. In attem ...

1 what is the break-even mortgage interest rate beir in the

1. What is the break-even mortgage interest rate (BEIR) in the context of financial leverage? Would you ever expect an investor to pay a break-even interest rate when financing a property? Why or why not? 2. Why might a ...

1 how are the results of factorial experimental designs

1. How are the results of factorial experimental designs reported in the research report? 2. What is the purpose of means comparisons, and what different types of means comparisons are there? What do they tell the resear ...

1 do outliers increase or decrease the magnitude of

1. Do outliers increase or decrease the magnitude of correlation coefficients? 2. What impact does reliability have on correlation? 3. Why can we infer causality from correlation?

According to an article in the wall street journal the us

According to an article in the Wall Street Journal: The U.S. Securities and Exchange Commission on Wednesday filed charges against the investment company GTF Enterprises Inc. . . . The SEC complaint alleges that Gedrey T ...

  • 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