Reference no: EM13748018
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.
|
Discuss bar code scanning in medication administration
: Discuss bar code scanning in medication administration and Discuss how the use of BCMA has affected patient safety
|
|
Purchase price of the new airline reasonable
: Because of the significant risk involved, lenders are promised a 12% return on their loans to the equity group. Is the purchase price of the new airline reasonable? Explain
|
|
What we have learned about athens rome sparta and persia
: what we have learned about Athens, Rome, Sparta, Persia, and other ancient societies. In the process, though, you must demonstrate a good understanding of the ancient world.
|
|
Employee orientations and performance appraisals
: Why is an attitude standard an important tool for supervisors to use and include in employee orientations and performance appraisals? Respond to at least two of your classmates' posts.
|
|
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..
|
|
What is meant by a leadership strategy
: What is meant by a leadership strategy - Outline the core elements of a well-developed leadership strategy (e.g., talent acquisition, talent sustainability, leadership practices).
|
|
Roles of the innate immune system
: Compare and contrast the major roles of the innate immune system and the acquired immune system
|
|
Explain important about african narrative by olaudah equiano
: What do you find interesting or important about An African Narrative by Olaudah Equiano? Is there a particular phrase or section that you find particularly meaningful or surprising?
|
|
Generate a genetic system for gram-positive
: Generate a genetic system for gram-positive that (based on the genetic material transference mechanisms): That allow us to know that the bacterial community is conducting quorum sensing
|