Reference no: EM13744990
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.
|
Analyze the significant implications of the issues
: Analyze the significant implications of the issues in question for market efficiency of the healthcare system. Provide a rationale for your response.
|
|
What can today sustainable architecture learn fromvernacular
: Montgomery Schuyler states "conformity to the environment is a prime virtue in domestic architecture". What can today's, sustainable architecture learn from the vernacular?
|
|
The total last year sales converted in mexican pesos
: Using nested queries (correlated query) to display the total Last Year Sales converted in Mexican pesos that occurred in July 1, 2005. Only nested/correlated queries will be accepted. Round the result set to two decimal places Unit10_ConvertedCommiss..
|
|
Recognize the income tax benefit of the operating loss
: Wynn Sheet Metal reported an operating loss of $160,000 for financial reporting and tax purposes in 2013. The enacted tax rate is 40%. Taxable income, tax rates, and income taxes paid in Wynn‘s first four years of operation were as follows:
|
|
Calculate the monthly mortgage payment
: 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..
|
|
Cash basis to the accrual basis
: A company switched from the cash basis to the accrual basis for recognizing warranty expense. The unrecorded liability for warranties was $2.1 million at the beginning of the year. Its tax rate is 35%. The company booked a year-end warranty liability..
|
|
List the number (count) of unreserved room
: List the guests by guest number, last name, first name and the number of times each guest has stayed in one of our hotels (include all reservations, past, current and future). Arrange the list in order from most-frequent stayer (greatest number of st..
|
|
Explain the reason for selecting topic identify the audience
: Explain the reason for selecting topic three (3), identify the audience, and provide a preliminary thesis statement. Identify and document six (6) credible sources (two (2) for each topic) that you would expect to use. Note: Wikipedia and other Web..
|
|
Estimate the ratio slide from the presentation
: Estimate the ratio slide from the presentation (Let's Estimate some Ratios for Ruckman (GAAP)). Follow the presentation and complete the second table (Let's Estimate some Ratios for Ruckman (IFRS).
|