Reference no: EM131222254 , Length: 7
Using MS Excel spreadsheet, create an assessment for each of the following problems:
1. Calculate the monthly mortgage payment of principal and interest for a loan with an initial balance of $250,000, an annual stated interest rate of 5%, and 30 years to maturity. Use Excel to develop this response and present your result within a separate page of the spreadsheet. Would only someone who makes a high income be able to afford this mortgage payment? Or would someone who makes the minimum wage be able to afford this mortgage payment?
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. Use the structure of problem 1 to develop a summary table that shows how the monthly payment would adjust for all options with an interest rate at 4%, 5%, and 6% 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 $500 per month into a mutual fund that you expect to return 8% per year. 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. Use problem 4 to develop a summary table that shows the accumulation for all options with an assumed return of 6%, 7%, 8%, 10%, and 12% as well as an investment of $100, $500, and $750. Use Excel to develop and present this summary table. Present the result in a separate page of the spreadsheet.
Write your assessment in a MS Word document and paste your spreadsheet analyses into the document.
Support your assessment with at least three resources. In addition to these specified resources, other appropriate scholarly resources, including older articles, may be included.
Your assessment should demonstrate thoughtful consideration of the ideas and concepts presented in the course by providing new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards. Be sure to adhere to Northcentral University's Academic Integrity Policy.
Length: 5-7 pages for Word and Excel documents (not including title and reference pages)
|
Course-human resource management foundations
: Topic: High Performance and the Choices Managers Make Note: Please answer EACH of the questions in at least 200 words. Answers should be correct, substantive, professional like a work of graduate student, and must be plagiarism-free. Use in-text ci..
|
|
What are implications for accounting in different countries
: ACC307 - Accounting Theory Assignment. Critically examine the validity of the above statement. What are the implications for accounting in different countries if the above allegation is true
|
|
Does the importance of these selected principles change
: In reviewing the text, the author identifies Ten Principles of the Community-Oriented Policing Chief. Select four of the principles, in rank order, that you deem to be most important for the Chief's success. Provide your opinion as to why these pr..
|
|
Examine its functionality and the data types and operations
: Investigate one of the advanced database applications discussed in Section 17.1, or a similar one that handles complex, interrelated data. In particular, examine its functionality and the data types and operations it uses.
|
|
Calculate the monthly mortgage payment of principal
: Calculate the monthly mortgage payment of principal and interest for a loan with an initial balance of $250,000, an annual stated interest rate of 5%, and 30 years to maturity
|
|
How the evaluations are used by the administration
: Thoroughly explain the importance of the community policing evaluation process, two forms of evaluation used in determining policing effectiveness, and how the evaluations are used by the administration. How does the community policing evaluation..
|
|
List the price and type of all rooms at the grosvenor hotel
: List the details of all rooms at the Grosvenor Hotel, including the name of the guest staying in the room, if the room is occupied.
|
|
Is there a transition area in your town or city
: Is there a "transition" area in your town or city? Does the crime rate remain constant in this neighborhood regardless of the racial, ethnic, or cultural composition of its residents?
|
|
What are your personal views of what your interviewee does
: Does this person/program focus more on crime control or due process? Why? Do you see your interviewee/program as being part of the official (traditional) criminal justice system, or are they outside of it (private company)?
|