Prepare a schedule of cash receipts from debtors
Please help. :)
Required:
Using Excel, answer the questions below. Use one tab per question and also include any written response within Excel.
Note that marks are also allocated for professional presentation and the use of formulas within Excel.
Â
Required: Using Excel, answer the questions below. Use one tab per question and also include any written response within Excel. Note that marks are also allocated for professional presentation and the use of formulas within Excel. QUESTION 3 (21 marks) Fussy Hair Ltd has decided to prepare a cash budget for the quarter ending 30st September 2016. Services are provided on 30 day credit terms. As at 1 July 2016, the Cash at bank ledger account had a debit balance of $500,000. The following estimates have been made for the next three months: July August September Sales 200,000 300,000 400,000 Cash purchases 150,000 140,000 160,000 Cash wages 15,000 20,000 28,000 Depreciation on plant 80,000 80,000 80,000 Electricity expenses 10,000 11,000 11,500 Insurance expenses 36,200 36,200 37,000 Loan repayment  0  20,000 20,000
Attachments:
Answers
Status NEW
Posted 21 Dec 2017 10:12 AM
My Price 10.00
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------
Not Rated(0)
