Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please see the image below. Starting out I want to input the amount just spent in the spent column, it automatically subtracts from the planned

Please see the image below. Starting out I want to input the amount just spent in the spent column, it automatically subtracts from the planned amount, and puts it in the remaining budget column. But then the next time I input in the spent column it subtracts it from the remaining budget column, that way I always know how much I have left to spend

Ex in case I'm not being clear: I go to the grocery store and spend $100 dollars. I put $100 in the spent column and hit enter, it then looks at my planned to spend column, subtracts $100 from the $1000 and inputs $900 into my remaining budget. Then the next time I go to the grocery store I spend $50. It now takes the $900 in the remaining budget column and subtracts the $50 inputted and puts $850 in the remaining budget and reverts the $50 just inputted into spent back to $0 so its clear the next time I want to input a number.

image text in transcribed

B B D E F 1 2 Income 5,846.00 5,846.00 Month Monthly Expenses Actual Spent 990.00 Remaining 3 Employment $ 4 Interest $ 5 Total $ 6 7 8 9 Mortgage $ 10 Insurance $ 11 Utilities $ 12 Gas $ 13 Eating Out $ 14 Child Care $ 15 Groceries $ 16 Lawn Service 17 Unknown Expen: $ 18 Car Expenses $ 19 Entertainement $ 20 Subtotal $ 21 Savings $ 22 Planned 990.00 $ 100.00 400.00 200.00 500.00 300.00 1,000.00 $70 286.00 300.00 700.00 4,846.00 $ 1,000.00 $ 990.00 4,856.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

What is the use of bootstrap program?

Answered: 1 week ago

Question

What is a process and process table?

Answered: 1 week ago

Question

What is Industrial Economics and Theory of Firm?

Answered: 1 week ago