70.2K

Verified Solution

Link Copied!

Based on Rule 3: Adding negative numbers to positive numberscount backwards,

= -$183,950 + $219,000 should turn into $183,950 - $219,000 = -$35,050

Since $219,000 in -$183,950 + $219,000 is a positive number is larger than 183,950, so the resulting difference should be a positive $35,050. Is this correct? How do get -$183,950 + $219,000 to turn into a positive 35,050 or $35,050 on the Microsoft Excel?

S.CO. Cash budget For the quarter ending September 30 July August September Quarter Cash balance beginning $40,000 $35,050 $35,435 $40,000 Add: Receipts from customers $520,000 $693,000 $779,500 $1,992,500 Total cash available (a) $560,000 $728.050 $814,935 $2,032,500 Less: disbursements: Purchase of inventory -$280,950 -$336,125 -$288,000 $905,075 Selling and admin expenses -$213,000 -S253,300 -$196,750 -5663,050 Capital expenditures -$200,000 -$90,000 -$290,000 Dividends paid -S50,000 Total disbursements (6) $743,950 -$679,425 -$484.750 -$1,908,125 Exces(deficiency) of receipts over disbursements (a-b)=c -$183,950 $48,625 $330,185 $124,375 Financing Borrowings $219,000 $219,000 Repayments -$11,000-$208.000 -$219,000 Interest: -S4,270 (219000*0.01) -$2,190 (219000-11000)*0.01 -2080 Tota Financing (d) $219,000 -$13,190 -$210,080 -$4,270 Cash balance, ending (c+d) $35,050 $35,435 $120,105 S120,105

Answer & Explanation Solved by verified expert

See Answer