Question

Us MS Excel to compute.
122-14 Dorothy Koehl recently leased space in the Southside Mall and opened Budgeting business, Koehl's Doll Shop. Business has been good, but Koehl has free run out of cash. This has necessitated late payment on certain orders, which turn, is beginning to cause a problem with suppliers. Koehl plans to burn from the bank to have cash ready as needed, but first she needs a forecast : just how much she must borrow. Accordingly, she has asked you to prepare cash budget for the critical period around Christmas, when needs will be espel cially high.

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

ACCOUNTS latest - Microsoft Excel (Product Activation Failed) Page Layout Formulas File Home Insert Data Review View Add-Ins Z AutoSum Cut AC Wrap Text Calibri 11 General E Copy Fill Merge & Center $ % Conditional Format Formatting as Table Styles Insert Delete Format Paste в IU* A 090 Cell Sort & Find & Format Painter Clear Filter Select Clipboard Font Alignment Number Styles Cells Editing FK16 FK FL FM FN FO FP FQ 2 CASH BUDGET 3 COLLECTIONS AND PURCHASES DECEMBER FEBRUARY 4. JANUARY 40000 60000 5 SALES 160000 6 PURCHASES 40000 40000 40000 7 PAYMENT FOR PURCHASES 140000 40000 40000 [-SUM(FM7:FM10)] 8 SALARIES 4800 4800 4800 2000 2000 [=SUM(FN7:FN10)] 9 RENT 2000 12000 [=SUM(FO7:FO10)] 10 TAXES 158800 46800 46800 11 TOTAL PAYMENTS 6000 12 CASH AT THE START OF FORECAST 400 6000 NET CASH FLOW 13200 13 1200 -6800 [-FM5-FM11] [=FN5-FN11] FO5-F011] 14 1600 -800 19200 15 CUMULATIVE NCF FM12 +FM13] [=FN12 +FN13] [-FO12 +FO13] 16 6000 17 TARGET CASH BALANCE 6000 6000 18 SURPLUS CASH OR LOANS NEEDED 4400 -6800 2000 [=FM15-FM17] [=FN15-FN17] [=FO15-FO17] 19 20 budget 45 days VARIANCE ВЕР, OL FL B-S profit loss SALES BUDGET float DIFF ANALYSIS ove cycle ROE, BV MV ratio dupont FIFO CASH BUDGET ratios DETROIT erences 130% WA 00:53 ENG 21-11-2019

ACCOUNTS latest - Microsoft Excel (Product Activation Failed) Page Layout Formulas File Home Insert Data Review View Add-Ins E AutoSum - Cut A A Wrap Text Calibri 11 General Copy Fill Merge & Center Paste B I U $ % , Conditional Format Cell Insert Delete Format Sort & Find & Format Painter Clear Filter Select Formatting as Table Styles Clipboard Font Alignment Number Styles Cells Editing fox FX16 FR FS FT FU FV FW FX FY FZ GA GB GC 2 b DECEMBER 3 0 [NO SALES REALIZED IN DECEMBER] A SALES 5 PURCHASES 40000 6 1 PAYMENT FOR PURCHASES 140000 7 2 SALARIES 4800 8 3 RENT 2000 4 TAXES 9 12000 158800 SUM(FU6:FU9)] 10 B 1+2+3+4TOTAL PAYMENTS 11 C CASH AT THE START OF FORECAST 400 -158800 FU4- 10] 12 A-B NET CASH FLOV -158400 [=FU11+FU 12] CUMULATIVE NCF 13 14 TARGET CASH BALANCE 6000 -164400 -FU13-FU 14] 15 SURPLUS CASH OR LOANS NEEDED 16 164400 17 ANSWER LOAN REQUIREMENT = 18 19 20 45 days ονε 4 130% FIFO CASH BUDGET budget VARIANCE BEP, OL FL float B-S profit loss SALES BUDGET cycle ROE, BV MV ratio ratios DETROIT dupont DIFF ANALYSIS erences + WA 00:53 ENG 21-11-2019