Projected Balance Sheet Figures in Thousand Taka Sales 17,953.00 Ratio Dec-20 Column1 Column2 Column3 Cash 4.18% 749.99 Accounts receivable 13.33% 2,393.73 Inventory 25% 4,488.25 Prepaid Expenses 1% 179.53 Current Assets 7,811.50 Net Plant and Equipment Pre-publication expenses Other assets Total Assets 12.92% 2.92% 2,714.00 2,318.72 524.99 13,369.21 9.20% Accounts Payable Current Portion of LT Debt Current Liabilities 1,651.98 178 1,829.98 5% Bonds 5 1/2 % Bonds 1,556.00 1,394.00 Term Debt 2,950.00 Common Stock Retained earnings 1,873.00 3,228.89 5,101.89 9,881.87 45% 9% Total Equity Total Liabilities and Equity Summary Income Statement Gross Profit Cash Operating costs Depreciation Profit Before Taxes Taxes = 40% Net Income Dividend 40% of net income Retained Earnings 8,078.85 1,615.77 2,500.00 3,963.08 1,585.23 2,377.85 951.14 1,426.71 (b) Use the excel sheet bottom to develop a cash budget for the month of March, April and May. You must tell me how much surplus and deficit you have in each of these three months. Cash in hand in March Taka 10,000. Each month must start with a cash balance of Taka 10,000. If there is any surplus, it must be moved to another account. If there is a deficit at the end of the month, money must be added to the cash account to bring the balance up to Tk 10,000. Projected Balance Sheet Figures in Thousand Taka Sales 17,953.00 Ratio Dec-20 Column1 Column2 Column3 Cash 4.18% 749.99 Accounts receivable 13.33% 2,393.73 Inventory 25% 4,488.25 Prepaid Expenses 1% 179.53 Current Assets 7,811.50 Net Plant and Equipment Pre-publication expenses Other assets Total Assets 12.92% 2.92% 2,714.00 2,318.72 524.99 13,369.21 9.20% Accounts Payable Current Portion of LT Debt Current Liabilities 1,651.98 178 1,829.98 5% Bonds 5 1/2 % Bonds 1,556.00 1,394.00 Term Debt 2,950.00 Common Stock Retained earnings 1,873.00 3,228.89 5,101.89 9,881.87 45% 9% Total Equity Total Liabilities and Equity Summary Income Statement Gross Profit Cash Operating costs Depreciation Profit Before Taxes Taxes = 40% Net Income Dividend 40% of net income Retained Earnings 8,078.85 1,615.77 2,500.00 3,963.08 1,585.23 2,377.85 951.14 1,426.71 (b) Use the excel sheet bottom to develop a cash budget for the month of March, April and May. You must tell me how much surplus and deficit you have in each of these three months. Cash in hand in March Taka 10,000. Each month must start with a cash balance of Taka 10,000. If there is any surplus, it must be moved to another account. If there is a deficit at the end of the month, money must be added to the cash account to bring the balance up to Tk 10,000
