Reference no: EM13754043
1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
|
Security weaknesses
: In this phase you will choose either Aircraft Solutions or Quality Web Design as the company you will work with. You will then identify potential security weaknesses
|
|
Discuss the development of a divided nation on vietnam war
: Identify and discuss the development of a divided nation and culture during the 1960's-70' with an emphasis on the Vietnam War.
|
|
Compute the groups charitable contribution deduction
: ParentCo's separate taxable income was $350,000, and SubCo's was $225,000. Consolidated taxable income before contributions was $400,000. Charitable contributions made by the affiliated group included $15,000 by ParentCo and $20,000 by SubCo. Compute..
|
|
Corporation is not eligible for consolidated return status
: Which corporation is not eligible for consolidated return status?
|
|
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..
|
|
The exchange qualifies as which type of transaction
: Hugh owns 90% of Quartz Corporation, and Stacy owns the other 10%. In exchange for all of the Quartz stock, Hugh receives 1,000 shares of Turquoise Corporation common stock (value $20,000), and Stacy receives 50 shares of Turquoise preferred (value $..
|
|
Business strategies for implementation
: Business strategies for implementation, rationale and scope, What value will the implementation offer, Both technology- and human-based safeguards used for information systems, Information comparing security requirements of out-sourcing and in-sourc..
|
|
Federal consolidated corporate income tax return
: Which is potentially a disadvantage of electing to file a federal consolidated corporate income tax return?
|
|
Development of the primis system for mcgraw-hill
: Evaluate which advantages were driving the development of the Primis system for McGraw-Hill. Business customers must perceive that products/services are solutions to their problems. Describe how the Primis system design kept this objective in mind
|