Financial Management Exercise, Exercises of Financial Management

Download Financial Management Exercise and more Exercises Financial Management in PDF only on Docsity! ETT SAN ANA Matrix No EX1804024 Lecturer Norzilah binti Mahmod Subject BASIC FINANCIAL MANAGEMENT Assessment Question 1 There are a twelve- month cash flow forecast (from May) f The forecast data are: Revenues are started from RM 950,000 and will increase 12% ev > Capital started balance with RM 600,000. > Loan - RM 1,100,000 for 15 years. > Purchases are made in the month of sale and are all for cash. The v revenues value. Other Expenses are started from RM 12,000 and will increase 10% Interest - 3.5% per year. Utilities - started from RM 10,000 and will be increase 5% every m Salaries - RM 300,000. Debtor’s collection - Company will collect 8% from revenue every | Maintenance expenses - Started from RM 24,000 and will be incre month before. Rental received - RM 50,000 every month. Renovation cost RM 85,000. Promotion expenses will spend every two months RM 15,000. Commission will receive every month 5% from revenue’s value. Company bough bought three (3) lorries RM 70,000 cash each. Exp each lorry is ten (10) years. vvvvvyv vvvvy a. Cashflow statement. b. Income statement for Bingo. c Balance Sheet. d. Based on the cash flow forecast, what action would you advise the manage take arises in May following year? or Bingo Sdn. Bhd. Company. rery month from month before. talue of purchases is 20% of from month before. onth from month before. month. ase 20% every month from ected using period for ar of this business to YEAR ENDED APR 2021 Sep-20 Oct-20 Nov-20 Dec-20 RM4,355,478.20 RM5,406,264.69 RM6,596,527.37 RM7,974,086.91 RM1,494,843.39 RM1,674,224.60 RM1,875,131.55 RM2,100,147.34 RM119,587.47 RM133,937.97 RM150,010.52 RM168,011.79 RM50,000.00 RM50,000.00 RM50,000.00 RM50,000.00 RM74,742.17 RM83,711.23 RM93,756.58 RM105,007.37 RM6,094,651.23 RM7,348,138.49 RM8,765,426.02 RM10,397,253.41 RM298,968.68 RM334,844.92 RM375,026.31 RM420,029.47 RM17,569.20 RM19,326.12 RM21,258.73 RM23,384.61 RM3,208.33 RM3,208.33 RM3,208.33 RM3,208.33 RM6,111.11 RM6,111.11 RM6,111.11 RM6,111.11 RM12,762.82 RM13,400.96 RM14,071.00 RM14,774.55 RM300,000.00 _|RM300,000.00 RM300,000.00 /RM300,000.00 RM49, 766.40 RM59,719.68 RM71,663.62 RM85,996.34 | ___frmas.ooa0o | fR25,000.00 | RM688,386.54 RM751,611.12 RM791,339.11 RM868,504.41 RM5,406,264.69 RM6,596,527.37 RM7,974,086.91 RM9,528,748.99 RM9,528,748.99 RM11,312,511.06 RM13,319,787.65 RM2,352,165.02 RM2,634,424.82 RM2,950,555.80 RM188,173.20 RM210,753.99 RM236,044.46 RM50,000.00 RM50,000.00 RM50,000.00 RM117,608.25 RM131,721.24 RM147,527.79 RM12,236,695.46 RM14,339,411.11 RM16,703,915.70 RM470,433.00 RM526,884.96 RM590,111.16 RM25,723.07 RM28,295.37 RM31,124.91 RM3,208.33 RM3,208.33 RM3,208.33 RM6,111.11 RM6,111.11 RM6,111.11 RM15,513.28 RM16,288.95 RM17,103.39 RM300,000.00 RM300,000.00 RM300,000.00 RM103,195.61 RM123,834.73 RM148,601.67 | pmas.ooo.00 | RM924,184.40 RM1,019,623.46 RM1,096,260.58 RM11,312,511.06 RM13,319,787.65 RM15,607,655.12 RM15,607,655.12 RM3,304,622.49 RM264,369.80 RM50,000.00 RM165,231.12 RM19,391,878.54 RM660,924.50 RM34,237.40 RM3,208.33 RM6,111.11 RM17,958.56 RM300,000.00 RM178,322.01 RM1,215,761.92 T Lorry(X)3 RM2 10,000.00 (CURRENT ASSET Cash RM18,176,116.62 (Total Current Asset Total Asset LIABILITY iLoan RM1,100,000.00 (-) Loan Repayment RM73,333.33 Total Liability IOWNER'S EQUITY Capital RM600,000.00 (+) Net Profit RM16,759,449.96 Total Owner's Equity Total Libility And Owner's Equity RM18,386,116.62 RM17,359,449.96