Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

im not getting the same totals and i dont know why Step 37 of 40: Cash Budget Form B 1 Add formulas. OWN N 1

im not getting the same totals and i dont know why
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Step 37 of 40: Cash Budget Form B 1 Add formulas. OWN N 1 Recap 1234 20,000 1,485,750 1,505,750 -B2 =SUM(B3:M3) -SUM(N2:N4) 7 8 10 10 11 (798,300) (163,800) (192,000) (84,000) (234,000) (1,472,100) 33,650 ESUM(B7:M7) -SUM(B8:M8) ESUM(B9:M9 SUM(B10:M10) ESUM(B11:M11) SUM(N7:N12) N5+N13 January Fel 2 Cash Balance, Beginning $ 20,000.00 $ 3 Collections 30000 2 YOUR TURN: Apply the Comma 6 Style to all numbers, make cells 7 B1:N1 bold, centered, and 8 underlined, and add top and 9 bottom borders to rows as applicable. Inputs supporting 1 January Fel 3 Sash Balance, Beginning 20,000 YOUR TURN: Modify the print settings by changing the orientation to Landscape and set the Height and Width to 1 Page. COMMissions TIZUOJ 9 Payroll (16,000) 10 Utilities (7,000) B 18 14 15 16 17 18 (6,290) 88,000 (88,000) (6,240) 17,000) SUM(C16:M16) SUM(B17:M17) =SUM(C18:M18) SUM(B20:M20) SUM(B21:M21) N14+N 20+N21 20 21 22 23 20,410 Inputs Supporting . Cash Budget 10 *** Students salernt hair RE ca SI . GOVT 1600 1100 0001 DI On WIE 1000 . ww CH 000 14 the w 11 View A Brian Brown -- 18W C C NO A- 5 % 9. diod Check Cell 2 O BOX Formatting Cation Dulle Sot AN Na Care A Data Available B D G H M N 20,000 30,000 50,000 90,750 123,00 132,000 135,000 138.000 126,000 126,000 141,000 144,000 129,000 129,000 147,000 150,000 90,750 20,000 1,485,750 123,000 132,000 135,000 138,000 141,000 144,000 147,000 150,000 1,505,750 -36540 12000 16000 -7000 19500 61800 12300 160X -7000 19500 -63300 12600 -160X -7000 19500 64800 12900 16000 7000 19500 66300 -13200 - 16000 -7000 19500 67800 13500 - 16000 7000 19500 69300 - 13800 16000 7000 19500 17000 14100 16000 70x70 19500 -72300 14400 16000 7000 19500 73800 -14700 16000 2000 19500 75300 15000 - 16000 7000 19500 76760 15300 16000 2000 19500 798300 163800 192000 4000 23-4000 91040 116600 -118400 120200 122000 123800 125600 127400 129200 131000 -13200 134060 1472100 (41,040) (25,850) 4,600 5,800 7,000 8,200 9,000 10.600 11,800 13.000 14,200 15,940 13,650 62000 620 47000 0 46380 0 1090 17000 0 1260 16000 0 14740 0 1420 15000 0 1520 14000 0 2170 B000 1710 73000 0 11290 1840 12000 0 10160 0 1960 11000 0 9000 2070 10000 0 2250 7000 0 0 -17960 232000 0 214040 0 13580 5830 620007 0 159101 0 124.301 0 7930 0 4750 0 0 0

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Economics Of Accounting Information In Markets

Authors: Peter Ove Christensen, Gerald Feltham

2nd Edition

1402072295, 9781402072291

More Books

Students also viewed these Accounting questions

Question

social sciencess

Answered: 1 week ago