Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer the following questions in the text box of this lab. Reference specific cells in your answers. How do you calculate the value in G
Answer the following questions in the text box of this lab. Reference specific cells in your answers.
How do you calculate the value in G Income?
How do you calculate the value in G Expenses?
How do you calculate the value in G the balance. Hint: the balance is the difference between income and expenses.
Add formulas to the spreadsheet to perform the calculations for ABC
Complete the Budget tab, using real data, made up information, or values from a projection into the future, whichever is most helpful to you.
Complete the blue cells in the MortgageCalculator tab using data from research:
Research on the Web to find a reasonable price for a house you might want to buy. Mortgage Loan Amount cell D is a purchase price of a house. Add the price for your dream house.
Research on the Web to find out the current mortgage interest rate. Interest Rate cell D is a value that changes week to week. Add today's interest rate.
Loan Term Yearscell D should be left at years, the standard duration for mortgages.
The Actual Monthly Payment cell D is the monthly payment you pay to the mortgage company and it can be greater than the minimum monthly payment. Paying more than the minimum monthly payment is often how people pay off their mortgage balance early. Add the monthly payment you decide on
Define a named range called MonthlyHousing, for cell D by right clicking on it then 'View more cell actions', then 'Define named range' By defining a named range, you have assigned the location of the MonthlyHousing variable. You can now refer to this variable in other parts of the workbook.
In the Budget tab's Rent or Mortgage field cell G reference the variable name MonthlyHousing. Notice how the balance cell G has changed.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started