Complete the following steps: Create a workbook to reflect the above. Populate the “?” with formulas Apply formula for the net, that is the income less the expenses Format for the target audience Verify that printing the worksheet will please target audience Does it make sense for you to move? Why or why not?
The story: You have been offered a new position with an increase in your pay, within the company, but will have to move to take the position. Comparable rentals to accommodate your lifestyle are 30% in the new city. Food is also pricier. You want to save the same percent of your income in the new job.
This exercise will challenge you on creating a worksheet, entering relative formulas, formatting, print setup, and analysis.
Income: Current Proposed
Yearly $50,000 $60,000
Monthly ? ?
Expenses Current Proposed
Rent $1000 $1300
Car payment $400 $400
Insurance $300 $400
Utilities $300 $400
Cell phone $75 $75
Food $250 $400
Savings 20% of pay 20% of pay
Total Monthly Expenses: ? ?
Net Income ? ?
Complete the following steps:
- Create a workbook to reflect the above.
- Populate the “?” with formulas
- Apply formula for the net, that is the income less the expenses
- Format for the target audience
- Verify that printing the worksheet will please target audience
- Does it make sense for you to move? Why or why not?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
