PROBLEMC Given the assumptions below concerning the Speedy Growth Company, construct the income statement, balance sheet and cash inflow-outflow statement for the company for the month of MARCH (you can either use Excel or fill in the statements on the following page - the entries on the following page should help guide you to the correct solutions). ASSUMPTIONS: Initial investment (made on January 1 when company begins operations) = $1,250,000 Selling price = $125 per unit; COGS = $100 per unit; Fixed costs = $25,000 per month; tax rate = 20% Credit policy = net 40 days (assume 75% of sales are on credit and 25% of sales are for cash) - all sales are eventually collected, meaning there is no bad debt. Inventory policy = 25 day supply (Note that this means inventory at the end of the month will be 25/30 of sales for that month. Thus, given that January sales = 4,000 units (see below), January ending inventory will be 3,333.33 units); Inventory is carried at cost (i.e., at $100 per unit), thus January inventory on the balance sheet = 333,333 - round all values to nearest whole number (thus, round $333,333.33 to $33,333). All bills are paid immediately (this implies that accounts payable and accruals = $0). Dividends = $15,000 per month; There are 30 days in every month; All revenues, costs, cash inflows and cash outflows are evenly distributed through the month If additional funds are needed, these will be in the form of debt (i.e., bank loans). The company will borrow money if cash = $0 on the balance sheet. The amount borrowed will be what is necessary to balance the balance sheet with cash = $0. Monthly Sales: January = 4,000 units, February = 10,000 units, March = 17,000 units Use the statements you created to answer the following questions. Record all answers as a dollar amount rounded to zero (0) decimal places, but do not record a dollar sign or any commas. If your answer is negative (i.e., a loss), put a hyphen before your answer with no space between the sign and the number. For example, record negative $23,243.83 as -23244. 10. Net income in March=_ 11. Addition to retained earnings in March = 12. Accounts receivable in March = 13. Debt in March = 14. Collection of cash sales + collection of credit sales in March = 15. Net cash flow in March = PROBLEMC Given the assumptions below concerning the Speedy Growth Company, construct the income statement, balance sheet and cash inflow-outflow statement for the company for the month of MARCH (you can either use Excel or fill in the statements on the following page - the entries on the following page should help guide you to the correct solutions). ASSUMPTIONS: Initial investment (made on January 1 when company begins operations) = $1,250,000 Selling price = $125 per unit; COGS = $100 per unit; Fixed costs = $25,000 per month; tax rate = 20% Credit policy = net 40 days (assume 75% of sales are on credit and 25% of sales are for cash) - all sales are eventually collected, meaning there is no bad debt. Inventory policy = 25 day supply (Note that this means inventory at the end of the month will be 25/30 of sales for that month. Thus, given that January sales = 4,000 units (see below), January ending inventory will be 3,333.33 units); Inventory is carried at cost (i.e., at $100 per unit), thus January inventory on the balance sheet = 333,333 - round all values to nearest whole number (thus, round $333,333.33 to $33,333). All bills are paid immediately (this implies that accounts payable and accruals = $0). Dividends = $15,000 per month; There are 30 days in every month; All revenues, costs, cash inflows and cash outflows are evenly distributed through the month If additional funds are needed, these will be in the form of debt (i.e., bank loans). The company will borrow money if cash = $0 on the balance sheet. The amount borrowed will be what is necessary to balance the balance sheet with cash = $0. Monthly Sales: January = 4,000 units, February = 10,000 units, March = 17,000 units Use the statements you created to answer the following questions. Record all answers as a dollar amount rounded to zero (0) decimal places, but do not record a dollar sign or any commas. If your answer is negative (i.e., a loss), put a hyphen before your answer with no space between the sign and the number. For example, record negative $23,243.83 as -23244. 10. Net income in March=_ 11. Addition to retained earnings in March = 12. Accounts receivable in March = 13. Debt in March = 14. Collection of cash sales + collection of credit sales in March = 15. Net cash flow in March =
