Ok I\'m stuck on these two questions I have a screen shot of my excel. I attache

Question

Ok I'm stuck on these two questions I have a screen shot of my excel. I attached the two formulas below I need to create that I'm stuck on

1). Enter a formula into cell D4 on the Savings worksheet. Your formula should add to the savings balance in cell D2 the result of subtracting the spending value in cell C4 from the net income value in cell B4.

2). Enter a formula into cell D5 on the  Savings worksheet. Your formula should add to the output in cell D4 the result of subtracting the spending value in cell C5 from the net income value in cell B5. Copy this formula and paste it into the range D6:D15 using the Paste Formulas command.

Savings Analysis Beginning Savings Balance $1,500 3 Month 4 Jan 5 Feb 6 Mar Net IncomelSpendin Savings 8 Ma 9 Jun 10 Jul 11 Au 12 13 Oct 14 Nov 15 Dec 16 $3,000$3,000 $3,000$2,000 $3,000$4,000 $3,000$3,000 $3,000$3,150 $3,000$3,300 $3,000$3,250 $3,000$2,700 $3,000$3,100 $3,000$3,350 $3,000$3,450 $3,000$3,700

Explanation / Answer

Savings Analysis

Beginning Savings Balance

$          1,500

Month

Net income

Spending

Savings

Jan

$          3,000

$          3,000

$          1,500

=D2+(B4-C4)

Feb

$          3,000

$          2,000

$          2,500

=D4+(B5-C5)

Mar

$          3,000

$          4,000

$          1,500

Apr

$          3,000

$          3,000

$          1,500

May

$          3,000

$          3,150

$          1,350

Jun

$          3,000

$          3,300

$          1,050

Jul

$          3,000

$          3,250

$              800

Aug

$          3,000

$          2,700

$          1,100

Sep

$          3,000

$          3,100

$          1,000

Oct

$          3,000

$          3,350

$              650

Nov

$          3,000

$          3,450

$              200

Dec

$          3,000

$          3,700

$           (500)

Savings Analysis

Beginning Savings Balance

$          1,500

Month

Net income

Spending

Savings

Jan

$          3,000

$          3,000

$          1,500

=D2+(B4-C4)

Feb

$          3,000

$          2,000

$          2,500

=D4+(B5-C5)

Mar

$          3,000

$          4,000

$          1,500

Apr

$          3,000

$          3,000

$          1,500

May

$          3,000

$          3,150

$          1,350

Jun

$          3,000

$          3,300

$          1,050

Jul

$          3,000

$          3,250

$              800

Aug

$          3,000

$          2,700

$          1,100

Sep

$          3,000

$          3,100

$          1,000

Oct

$          3,000

$          3,350

$              650

Nov

$          3,000

$          3,450

$              200

Dec

$          3,000

$          3,700

$           (500)

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.