2???,t. A t ? () . _ . ?.2-.T , @??100%?0 Search in Sheet A HomeLayout Tables Ch

Question

2???,t. A t ? () . _ . ?.2-.T , @??100%?0 Search in Sheet A HomeLayout Tables Charts SmartArt Formulas DataReview Alignment ? | Fill . : Calibri (Body) | | 1 1 | ' | | A- Aa Formatting Insert Delete Farmat Themes C32 1 Billy Bob's House of Merchandise 2 Cash Budget 2019 NGUYEN Annual Interest Rate on Short Term Borrowings 2019 June Sept 8 Beginning cash balance 9 Cash receipts: 10 Cash available $ 25,000 1,004,250 1255,531 2,674477 4,042,227 4,32,108 1,008,870 $ 1,000,233 2,781,344 4,904,290 S 5,194053 $ 1,808,815 30,051.196 2.50 2.275,000 4450,000 44,827,500 3,735 4,887,500 4,154,250 $3,530,531$8,574,477 6,317,227 6,192,108 6,908,870 4,000,233 5,781,344 10,804,290 7469,053 6,258,815 74,878,696 6,239 4862500 3,10000 2.000 5,900,000 2,275000 1840,000 5,900,00 3,000,000 3,000,000900,000 2275,000 4450,0004,827,00 3,735. 12 Cash payments: 13 Capital expenditures 14 Purchases of Merch Inventory 15 Selling and administrative expenses306,000 313,000 313000 320,000 346,000 $25,000$ 600,000 15,000$ $300,000$ 125,000 $45,000 S 1,110,00 4,212,250 1319,119 1 528,054 4,212,2501319119 5,260,238 5,260,238969 528,054 260238 5260238 1 105,306 33,855,071 2,821 363,000 334,00000350,000355,00057000 4,077,000 339 3,920 Interest expense 6,600 4,400 2,920 17 Total cash payments 4,543,250 2,238,719 856,054 ,50 1965,119 5,623,238 5 5,760,638 926,889 877,054 5,610,238 5,660,238462,306 39,055.991 3.2 19 Ending cash balance before financing 20 Minimum cash balance desired 5,796,509 (1,000,000, S 6557s0)915,531 1,674477 3,0,227 3,352,108(431,130 148,233 2,073,344 S 3,904,290 4,194,053 808,815 $4,796,509 344,25o (1,000,000) 1,915,531 (1,00 OOO 2,674,477,042,227 5 4,352,108 (1,000,000) 568,870 $ 1,148,233 3,073,344 (1,000,000) 4,904,29o5,194,053 (1,000,000, 1,808815 1,000,000, (1,000,000 (1,00 ,000 (1,000,00? 1,000,000 1,000 000? Projected cash excess (deficiency) 23 Financing 24 Borrowing 40,000 440.000 (1 008,870 1,000,233 2,781,344 660,000 1,100,00 Principal repayments 148,000)(292,000 26 Total effects of financing 28 Ending cash balance 1,255,531 4,042,227 5,194,053 ,808,815 5,796,50 4,352,108 4,904,290 30 31 32 36 .. Cash Budget CORRECTED TEMPLATE Cash Budget Select destination and press ENTER or choose Paste Cash Receipts Budget CAP Exp Budget· Purch of Merch Budget·S&A; Budget Shi ? Normal view Sum-0

Explanation / Answer

The formula will start from the cell D25, which is as follows:-

=-IF(D21<0,0,IF(SUM($C$24:C25)>0,MIN(SUM($C$24:C25),ROUND(D21,-3)),0))

You can simply copy the formula into other cells in row 25.

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

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