Project #76822 - Excel Project

 

Download the Activity Sheet & Budget Spreadsheet files.  This project is broken up into three parts. The Amortization Spreadsheet is for both Part 1 & Part 2. I would suggest first using the prototype numbers (found as a screenshot picture in the Activity Sheets) to verify that the formulas and the flow of the spreadsheet are accurate before inputting your own data from your virtual home purchase. The Financial Toolbox Spreadsheet is a resource to help you with some of the calculations for Part 3, the Case Study. This spreadsheet contains several mini calculators which already have values entered that you will need to be replace with the values required for this assignment. Additionally, you will need to use some of the mini calculators several times, and others may not be needed at all. When using a spreadsheet, note that negative amounts are displayed in red font, parentheses, or both. Furthermore, note that the Case Study Sheet references Unit 4D of your textbook, but this is inaccurate. You should refer to Chapter 11 of your textbook as an additional resource. What You Need to Submit For Part 1, you will need to submit a screenshot of the current fixed interest rates for a home mortgage from the website you used to find this information. You will also need to submit a screenshot of the home with purchase price that you will be using for this project from the website where you found it listed. You can submit these screenshots as .jpeg files or you can paste the images into a word processing software and export them as .pdf files for submission.  

 

This project is broken up into three parts. The Amortization Spreadsheet is for both Part 1 & Part 2. I would suggest first using the prototype numbers (found as a screenshot picture in the Activity Sheets) to verify that the formulas and the flow of the spreadsheet are accurate before inputting your own data from your virtual home purchase. The Financial Toolbox Spreadsheet is a resource to help you with some of the calculations for Part 3, the Case Study. This spreadsheet contains several mini calculators which already have values entered that you will need to be replace with the values required for this assignment. Additionally, you will need to use some of the mini calculators several times, and others may not be needed at all. When using a spreadsheet, note that negative amounts are displayed in red font, parentheses, or both. Furthermore, note that the Case Study Sheet references Unit 4D of your textbook, but this is inaccurate. You should refer to Chapter 11 of your textbook as an additional resource. What You Need to Submit For Part 1, you will need to submit a screenshot of the current fixed interest rates for a home mortgage from the website you used to find this information. You will also need to submit a screenshot of the home with purchase price that you will be using for this project from the website where you found it listed. You can submit these screenshots as .jpeg files or you can paste the images into a word processing software and export them as .pdf files for submission. For Part 1 & Part 2, you will need to submit just one completed Amortization Spreadsheet Excel file (if you use another spreadsheet software, please export to a .xls file). When you submit the spreadsheet file, please Also for Part 1 & Part 2, you will need to submit an Analysis & Discussion Word file for each of these two parts (again if you use another word processing software, please export to a .doc file). The Part 1 document will address Analysis Questions 1-4 and Discussion Questions 1-4. The Part 2 document will address Analysis Questions 1-5 and Discussion Questions 1-2. While some of the Analysis questions may only require one word answers, each Discussion answer should be at minimum one complete sentence to approximately one paragraph in length. For Part 3, the Case Study, you will need to submit a Procedure, Analysis, & Discussion Word file (again if you use another word processing software, please export to a .doc file). This document will address the Procedure Questions 1-3, Analysis Table, and Discussion Questions 1-9 (as indicated on the Case Study Sheet, Question 9 is a bonus question). While some of the Procedure questions may only require one word answers, each Discussion answer should be at minimum one complete sentence to approximately one paragraph in length. When completing the Analysis Table in a word processing software, you should recreate it in a similar format as it is presented in the Case Study Sheet, but it does not need to have the same exact formatting. If you use any additional resources to answer any of these questions you must cite these sources by simply providing a link for information found on the internet or author and title for information found in hardcopy sources. All documents should be grammar and spell checked. Also, please use an appropriate font type and size, such as Times New Roman 12pt, and 1.5 line spacing. To review, for this assignment you will need to upload a Mortgage Rate file, a House Listing file, an Amortization Spreadsheet file, a Analysis and Discussion Part 1 file, a Analysis and Discussion Part 2 file, and a Procedure, Analysis, and Discussion for Case Study file.

 

Subject Mathematics
Due By (Pacific Time) 07/19/2015 12:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy