Question

I need help with this cash flow forecast! I haven’t studied accounting in two years and everything I know doesn’t seem to want to come out and help me! Need to know ASAP please many thanks in advance

Done Unit 5 MA- D2-TEMPLATE.xlsx Prepare the cashftow The director provided you with some geidance l: All sales were made on credit to retailers within the first eight moeths of the year. There were no sales within the last theee months of the year 2: Tuflenmark areange for retailers to pay over a three monks period in ฟื้e fatio of 90%,in the fiest meh3% in the sooland 20% in the third :All expeses are paid on the last day of each month Igmore depreciation : Assume that the sales and expense occur evenly throughout the respective period (8 months for sales and 12 months for expenses) :The balance sheet halance from the previous period include: Tools of £4000; cash of E2000, Share capital of £100 and Retained profit b/T of t5900 6: Closing stock of 192400 In month 4 Tuffen Mark Plan to buy a more advanced MMachine for t620000 in cash :You may use ratios to uncover any insight to tell Mark Advice Mark (should he have paid in cash or negotiated a different arrangement-give reason) and the projected balance sheet for the mest 12 monhs period assuming the same level of activity (all things being equal) Tuffenmark Ltd. Cash Flow Forecast for the next 12 MI M2 M3 M4 M5 M7 MMS Mi0 MI2 Sales Receipt 000 115000 I15000 9000 69000 second month Thind month Total Receipt 29000 Selling & Admin( 60 000) Manu Oh (180 000) Direct Expo New Adhanced Machine Total Payments Net Cash Cash B Cash e/f 0 (1215000-620000) 529000 (7000-2000

Answer 1