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 12. Use the Excel sheet. (Link Given) (a) Fill out the box for a. Cash sales in March. b. Cash collection boxes for the month of May. C. Scheduled labour and merchandise expenses box for the month of April. 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 12. Use the Excel sheet. (Link Given) (a) Fill out the box for a. Cash sales in March. b. Cash collection boxes for the month of May. C. Scheduled labour and merchandise expenses box for the month of April