Reference no: EM13745632
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.
|
Differences between horizontal and vertical
: Discuss the differences between horizontal, vertical and conglomerate mergers and how those differ from a joint venture.
|
|
Describe why or why not a pure service industry
: Describe why or why not a pure service industry (e.g. accounting or law firms) may or may not be able to implement this type of technique.
|
|
What ppe would you require for your team members
: What PPE would you require for your team members and the recovery workers - short term and then later in the recovery effort. What testing equipment would you require for your team members
|
|
Write an essay on baroque style
: Write an essay on Baroque Style. Please respond to the following, using sources under the Explore heading as the basis of your response.
|
|
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 was greek-like about hellenistic civilization
: What was Greek-like about Hellenistic civilization?
|
|
Discuss the economic impacts of implementing your plan
: Discuss the economic impacts of implementing your plan versus the financial impacts of making no change in our current use.
|
|
How do you understand the bible and the historical jesus
: Describe in detail how do each of you understand the following; The Bible, The Historical Jesus, Paul, The Kingdom of God, the protestant/catholic relationship and the role of women in the church.
|
|
Question regarding the high-quality bonds
: Erika opened an account with the Safety First Bond Fund, a mutual fund that invests in high-quality bonds whose investors have earned 5% per year in the past. Kitty invested in the New Issue Bio-Tech Fund, which invests in small, newly issued bio-..
|