Reference no: EM13974535
Develop an assessment of each of the following problems:
Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity. Use Excel to develop this response and present your result within a separate page of the spreadsheet.
Develop the amortization table for the loan outlined in problem 1. Use an Excel spreadsheet to develop and present this table. Present this result in a separate page of the spreadsheet.
Further, given the structure of problem 1, develop a summary table showing how the monthly payment would adjust for all options with an interest rate at 5%, 6% and 7% as well as a maturity at 15 years, 20 years and 30 years. Use Excel to develop and present this summary table. Present the results in a separate page of the spreadsheet.
Assume that you want to retire in 30 years. You intend to invest $200 per month into a mutual fund that you expect to return 12% per year (1% monthly). If you continue making these monthly investments for 30 years, what amount of money will you have at the end of the 30th year? Use Excel to develop and present this result. Present the result in a separate page of the spreadsheet.
Given problem number 4, please develop a summary table showing the accumulation for all options with an assumed return of 10%, 11%, 12%, 13% and 14% as well as an investment of $150, $200 and $250. Use Excel to develop and present this summary table. Present the result in a separate page of the spreadsheet.
You should have a single spreadsheet file for submission with 5 pages for the 5 parts of the assignment above.
|
Compute the cost of fixed income securities for corporation
: The treasurer of Sutton Security Systems is asked to compute the cost of fixed income securities for her corporation. Even before making the calculations, she assumes the aftertax cost of debt is at least 2 percent less than that for preferred stock...
|
|
What is the current market price of these bonds
: Jackson corporation's bonds have 12 years remaining to maturity. interest is paid annually, the bonds have a $1000 per value, and the coupon interest is 8%. the bonds have a yield to maturity of 9%. what is the current market price of these bonds?
|
|
Multiple investments to consider with differing risk levels
: Assume your firm has multiple investments to consider each with differing risk levels. How can differing risk levels be incorporated into NPV analysis? How can they be incorporated into IRR analysis?
|
|
Preferred stock dividends are tax deductible
: All else equal, an increase in a company’s stock price will increase its marginal cost of new common equity, re. If a company’s tax rate increases but the YTM of its noncallable bonds remains the same, the after-tax cost of its debt will fall. When c..
|
|
Calculate the monthly mortgage payment of principal
: Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity. Use Excel to develop this response and present your result within a se..
|
|
Target capital structure-debt-preferred stock-common equity
: Rollins Corporation is constructing its MCC schedule. Its target capital structure is 20 percent debt, 20 percent preferred stock, and 60 percent common equity. Its before-tax cost of debt is 12%. The firm's net income is expected to be $1 million, a..
|
|
Use the annual sales figure when evaluating this project
: Winnebagel Corp. currently sells 30,000 motor homes per year ay $73,000 each and 14,000 luxury motor coaches per year at $120,000 each. The company wants to introduce a new portable camper to fill out its product line; it hopes to sell 25,000 of thes..
|
|
Firm relax collection efforts if opportunity cost of funds
: The Boyd Corporation has annual credit sales of $1.6 million. Current expenses for the collection department are $35,000, bad-debt losses are 1.5%, and the days sales outstanding is 30 days. Should the firm relax collection efforts if the opportunity..
|
|
Which alternative has lowest effective annual interest rate
: Cost of Bank Loans Del Hawley, owner of Hawley’s Hardware, is negotiating with First City Bank for a 1-year loan of $50,000. First City has offered Hawley the following alternatives. Calculate the effective annual interest rate for each alternative. ..
|