Old MathJax webview

Old MathJax webview

help with formula please

b) Assume that the assets and accounts payable follow the sales. However, other items in the liabilities and equities will follow a constant amount in 2019, following 2018. Make a pro-forma balance sheet, for the year 2019, following lecture. (Do your calculations on the excel sheet) c) Determine how you can adjust the balance in the balance sheet using plug variable. (Write your answer here. You do not have to show it on the excel sheet) 3 4 5 Balance sheet 6 7 8 19 20 21 22 23 24 25 26 500 2000 4000 6500 5000 11500 % of sales Liabilities and Equity 10% Liabilities 40% Account pa 80% Notes paya Total curre Long term 100% Owners equity Common a Retained e Ttoal equit Total liabil 900 2500 n/a 3400 n/a 3000 n/a 2000 n/a 3100 n/a 5100 11500 Pro forma blaance sheet that follows the percentage of sales (if applicable) Asset side Current assets 18% Accounts receivables Inventory Total current assets Fixed or non-current assets PP&E Total asset % of sales b) Assume that the assets and accounts payable follow the sales. However, other items in the liabilities and equities will follow a constant amount in 2019, following 2018. Make a pro-forma balance sheet, for the year 2019, following lecture. (Do your calculations on the excel sheet) c) Determine how you can adjust the balance in the balance sheet using plug variable. (Write your answer here. You do not have to show it on the excel sheet) 123456789 B 3 Sales 4 Less: costs 5 Gross profit 6 Less: Taxes 7 Net income Dividend Addition to retained earnings 9 10 11 12 13 Income statement 5000 3500 1500 315 1185 474 711 D % of sales 70% 30% 6.30% E F G Proforma income statement where it is projected that sales will grow at 20% Sales Less: costs Gross profit Less: Taxes Net income Dividend Addition to retained earnings H 6000 % of sales a) You income statement and balance sheet information for year 2018 are given in the excel sheet. You are making a projection that the sales will grow at 20% in the next year. Make a pro-forma income statement for the year 2019, following lecture. You have to also calculate dividend and retained earnings assuming that the dividend rate is 50% of net income in each year. (Do your calculations on the excel sheet) b) Assume that the assets and accounts payable follow the sales. However, other items in the liabilities and equities will follow a constant amount in 2019, following 2018. Make a pro-forma balance sheet, for the year 2019, following lecture. (Do your calculations on the excel sheet) c) Determine how you can adjust the balance in the balance sheet using plug variable. (Write your answer here. You do not have to show it on the excel sheet) 3 4 5 Balance sheet 6 7 8 19 20 21 22 23 24 25 26 500 2000 4000 6500 5000 11500 % of sales Liabilities and Equity 10% Liabilities 40% Account pa 80% Notes paya Total curre Long term 100% Owners equity Common a Retained e Ttoal equit Total liabil 900 2500 n/a 3400 n/a 3000 n/a 2000 n/a 3100 n/a 5100 11500 Pro forma blaance sheet that follows the percentage of sales (if applicable) Asset side Current assets 18% Accounts receivables Inventory Total current assets Fixed or non-current assets PP&E Total asset % of sales b) Assume that the assets and accounts payable follow the sales. However, other items in the liabilities and equities will follow a constant amount in 2019, following 2018. Make a pro-forma balance sheet, for the year 2019, following lecture. (Do your calculations on the excel sheet) c) Determine how you can adjust the balance in the balance sheet using plug variable. (Write your answer here. You do not have to show it on the excel sheet) 123456789 B 3 Sales 4 Less: costs 5 Gross profit 6 Less: Taxes 7 Net income Dividend Addition to retained earnings 9 10 11 12 13 Income statement 5000 3500 1500 315 1185 474 711 D % of sales 70% 30% 6.30% E F G Proforma income statement where it is projected that sales will grow at 20% Sales Less: costs Gross profit Less: Taxes Net income Dividend Addition to retained earnings H 6000 % of sales a) You income statement and balance sheet information for year 2018 are given in the excel sheet. You are making a projection that the sales will grow at 20% in the next year. Make a pro-forma income statement for the year 2019, following lecture. You have to also calculate dividend and retained earnings assuming that the dividend rate is 50% of net income in each year. (Do your calculations on the excel sheet)