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.
Calculate the annual end of year loan payment amount.
Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.
Prepare a one page executive summary for the CEO, Linda Messineo,with the loan payment schedule explaining 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 calculate the annual payment. Next you will use the IPMT function to find the interest portion for each of the three years.
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.
Calculate the annual end of year loan payment amount.
Prepare a loan amortization schedule showing the interest and principal break down of each of the three loan payments.
Prepare a one page executive summary for the CEO, Linda Messineo,with the loan payment schedule explaining 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 calculate the annual payment. Next you will use the IPMT function to find the interest portion for each of the three years.
For unlimited access to Homework Help, a Homework+ subscription is required.
Related questions
1. On the day you entered college, you borrowed $30,000 from your local bank. The terms of the loan include an interest rate of 4.75 percent. The terms stipulate that the principal is due in full one year after you graduate. Interest is to be paid annually at the end of each year. Assume that you complete college in four years. How much total interest will you pay on this loan assuming you paid as agreed? (Hint: This is simple interest, not an amortized loan)
$7,267 |
$7,400 |
$7,125 |
$1,500 |
$1,425 |
2. Mr. Miser loans money at an annual percentage rate of 18 percent. Interest is compounded daily. What is the effective rate Mr. Miser is charging on his loans?
3. You just acquired a 30-year mortgage in the amount of $179,500 at 4.75 percent interest, compounded monthly. Payments will be equal over the life of the loan with the first payment due one month after the date of the loan. How much of the first payment will be interest?
4.The Great Giant Corp. has a management contract with its newly hired president. The contract requires a lump sum payment of $24,500,000 be paid to the president upon the completion of her first 6 years of service. The company wants to set aside an equal amount of funds each year to cover this anticipated cash outflow. The company can earn 5 percent on these funds. How much must the company set aside each year for this purpose?
Set up an amortization schedule for a $40,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 7%. Round your answers to the nearest cent. Enter "0" if required
Year | Payment | Repayment Interest | Repayment of Principal | Balance |
1 | $ | $ | $ | $ |
2 | $ | $ | $ | $ |
3 | $ | $ | $ | $ |
4 | $ | $ | $ | $ |
5 | $ | $ | $ | $ |
Total | $ | $ | $ |
How large must each annual payment be if the loan is for $80,000? Assume that the interest rate remains at 7% and that the loan is paid off over 5 years. Round your answer to the nearest cent.
$
How large must each payment be if the loan is for $80,000, the interest rate is 7%, and the loan is paid off in equal installments at the end of each of the next 10 years? This loan is for the same amount as the loan in part b, but the payments are spread out over twice as many periods. Round your answer to the nearest cent.
$
Why are these payments not half as large as the payments on the loan in part b?
-Select- Item 26
I. Because the payments are spread out over a longer time period, more principal must be paid on the loan, which raises the amount of each payment.
II. Because the payments are spread out over a longer time period, less interest is paid on the loan, which raises the amount of each payment.
III. Because the payments are spread out over a longer time period, less interest is paid on the loan, which lowers the amount of each payment.
IV. Because the payments are spread out over a shorter time period, more interest is paid on the loan, which lowers the amount of each payment.
V. Because the payments are spread out over a longer time period, more interest must be paid on the loan, which raises the amount of each payment.
You have a $2 million portfolio consisting of a $100,000 investment in each of 20 different stocks. The portfolio has a beta of 1. You are considering selling $100,000 worth of one stock with a beta of 0.8 and using the proceeds to purchase another stock with a beta of 1.3. What will the portfolio's new beta be after these transactions? Do not round intermediate calculations. Round your answer to two decimal places.
You have observed the following returns over time:
Year | Stock X | Stock Y | Market |
2009 | 12% | 11% | 10% |
2010 | 19 | 5 | 9 |
2011 | -15 | -8 | -12 |
2012 | 5 | 1 | 1 |
2013 | 20 | 13 | 13 |
Assume that the risk-free rate is 3% and the market risk premium is 6%. Do not round intermediate calculations.
What is the beta of Stock X? Round your answer to two decimal places.
What is the beta of Stock Y? Round your answer to two decimal places.
What is the required rate of return on Stock X? Round your answer to one decimal place.
%
What is the required rate of return on Stock Y? Round your answer to one decimal place.
%
What is the required rate of return on a portfolio consisting of 80% of Stock X and 20% of Stock Y? Round your answer to one decimal place.
%
Your division is considering two investment projects, each of which requires an up-front expenditure of $25 million. You estimate that the cost of capital is 9% and that the investments will produce the following after-tax cash flows (in millions of dollars):
Year | Project A | Project B |
1 | 5 | 20 |
2 | 10 | 10 |
3 | 15 | 8 |
4 | 20 | 6 |
What is the regular payback period for each of the projects? Round your answers to two decimal places.
Project A years
Project B years
What is the discounted payback period for each of the projects? Round your answers to two decimal places.
Project A years
Project B years
If the two projects are independent and the cost of capital is 9%, which project or projects should the firm undertake?
-Select-Project AProject BBoth projectsItem 5
If the two projects are mutually exclusive and the cost of capital is 5%, which project should the firm undertake?
-Select-Project AProject BItem 6
If the two projects are mutually exclusive and the cost of capital is 15%, which project should the firm undertake?
-Select-Project AProject BItem 7
What is the crossover rate? Round your answer to two decimal places.
%
If the cost of capital is 9%, what is the modified IRR (MIRR) of each project? Round your answers to two decimal places.
Project A %
Project B %