Calculation: Each part of the project requires calculations and answering questions based on the calculations. All calculations and answers must be done on the spreadsheet. Only data given or calculated in the spreadsheet will be accepted. All arguments in a calculation must be done using reference cells.

Formatting: Each part of the project requires the creation of charts, tables, and text answers. Cells should be formatted so that the data provided, calculations, charts, tables, and text answers are arranged in an organized matter.

Part $1)$ you purchase a house for $($see Column B$)$ using a $30-$year adjustable$-$rate mortgage that makes monthly payments with an annualized interest Rate a $($see Column C$).$ After $($b$)$ number of years $($see Column D$),$ the interest rate changes to Rate b $($see Column E$)$ and after an additional $($c$)$ number of years $($see Column F$)$ the interest rate changes to Rate c $($see Column G$).$

Calculate: How much are the monthly mortgage payments under each interest rate?

Calculate: Explain how the changes in time, interest rate and principal change the monthly mortgage payments.

Formatting: create a column chart showing all three mortgage payments.

Formatting: Format cells to display data and answers