1. Handyman wishes to prepare forecasted balance sheet and income statement for
ID: 2458919 • Letter: 1
Question
1. Handyman wishes to prepare forecasted balance sheet and income statement for 2013. Use the original financial statement numbers for 2012 [ given above] as the basic for forecast, along with the following additional information:
a. Sales in 2013 are expected to increase by 40% over 2012 sales of $700.
b. Cast will increase at the same rate as sales.
c. The forecasted amount of accounts receivable in 2013 is determined using the forecasted value for the average collection period. For simplicity, do the computations using the end-of-period account receivable balance instead of the average balance. The average collection period for 2013 is expected to be 14.08 days.
d. The forecasted amount of inventory in 2013 is determined using the forecasted value for the number of day’s sales in inventory (computed using the end – of – period inventory balance). The number of day’s sales in inventory for 2013 is expected to be 107.6 days.
e. The forecasted amount of accounts payable in 2013 is determined using the forecasted value for the number of day’s sales in accounts payable (computed using the end – of – period accounts payable balance). The number of day’s purchases in accounts payable for 2013 is expected to be 48.34 days.
f. The $160 in operating expenses reported in 2012 breaks down as follows: $5 depreciation expense, $155 other operating expenses.
g. New long-term debt will be acquired (or repaid) in an amount sufficient to make Handyman’s debt ratio (total liabilities divided by total assets) in 2013 exactly equal to 0.80.
h. No cash dividends will be paid in 2013.
i. New short-term loans payable will be acquired in an amount sufficient to make Handyman’s current ratio in 2013 exactly equal to 2.0.
j. The forecasted amount of property, plant, and equipment (PP&E) in 2013 is determined using the forecasted value for the fixed asset turnover ratio. For simplicity compute the fixed asset turnover ratio using the end-of-period gross PP&E balance. The fixed asset turnover ration for 2013 is expect to be 3.518 times
k. In computing depreciation expense for 2013, use straight –line depreciation and assume a 30 -year useful life with no residual value. Gross PP&E acquired during the year is depreciated for only half the year. In other words, depreciation expenses for 2013 is the sum of two parts: (1) a full year of depreciation on the beginning balance in PP&E, assuming a 30-year life and no residual value and (2) a half-year of depreciation on any new PP&E acquired during the year, based on the change in the gross PP&E balance.
l. Assume an interest rate on short-term loans payable of 6.0% and on long-term debt of 8.0%. Only a half -year’s interest is charged on loans taken out during the year. For example, if short-term loans payable at the end of 2013 are $15 and given that short-term loans payable at the end of 2012 were $10, total short-term interest expense for 2013 would be $0.75 [($10x0.06)+($5x0.06x1/2)].
m. In addition to preparing the forecasted financial statements for 2013, Handyman also wishes to prepare forecasted financial statements for 2014. All assumption applicable to 2013 are also assumed to be applicable to 2014. Sales in 2014 are expected to be 40% higher than sales in 2013.
Clearly state any additional assumption that you make.
2. For each forecasted year, 2013 and 2014, state whether Handyman is expected to issue new shares of stock or to repurchase shares of stock.
3. Repeat (2), with the following changes in assumptions:
a. The debt ratio in 2013 and 2014 is exactly equal to 0.70.
b. The debt ratio in 2013 and 2014 is exactly equal to 0.95.
4. Comment on how it is possible for company to have negative paid-in capital
Handyman Company Comparative Balance Sheet Year-End 2012 Assets Current assets: Cash Inventories Accounts receivable Total current assets 10.00 153.00 27.00 190.00 Fixed assets: 199.00 9.00 190.00 and equip Pro Accumulated depr Net fixed assets ation Total assets $380.00 Liabilities and owner's equi Current liabilities: Accounts payable Short-term loans payable Total current liabilities 74.00 10.00 $84.00 Long-term liabilities: Long-term debt Total long-term liabilities 207.00 $207.00 Total Liabilities $291.00 Owner's equi ital stock Retained earnings Total owner's equit 50.00 39.00 $89.00 Total lia bilities and owner's equi $380.00Explanation / Answer
Answer to Question No.1 HANDYMAN COMPANY ASSETS Current Assets Cash 14.00 19.60 Inventories 214.20 299.88 Accounts Receivable 37.80 52.93 Total Current Assets 266.00 372.40 Fixed Assets Property and equipment 278.57 389.99 Accumulated depreciation 16.96 28.09 Net fixed assets 261.61 361.90 Total Assets 527.61 734.30 Liabilities & owners equity Current liabilities Accounts payable 96.23 134.72 Short term loans payable 36.77 51.48 Total current liabilities 133.00 186.20 Long term liabiliites: Long term debt 289.09 401.24 Total liabiliites 422.09 587.44 Owner's equity Capital stock 61.72 96.69 Retained earnings 43.80 50.17 Total onwers equity 105.52 146.86 Total liabilites & owner's equity 527.61 734.30 Income Statement 2013 2014 Sales 980.00 1372.00 Cost of goods sold 726.60 1017.24 Gross margin 253.40 354.76 interest expense-Short term 1.40 2.65 Long term 19.84 27.61 operating expense-Depn 7.96 11.14 Others 217.00 303.80 income before tax 7.20 9.56 income tax 2.40 3.19 Net Income 4.80 6.37 Retained earnings opening balance 39 43.80 net income for the year 4.80 6.37 dividends 0 0 closing balance 43.80 50.17 Assumptions: 1) All costs are assumed to increase by 40% Answer to Question No. 2 For both the years Handyman is expected to issue new shares for $11.72 & $34.97 Answer to Question NO. 3 With debt ratio of 70% HANDYMAN COMPANY ASSETS Current Assets Cash 14.00 19.60 Inventories 214.20 299.88 Accounts Receivable 37.80 52.93 Total Current Assets 266.00 372.40 Fixed Assets Property and equipment 278.57 389.99 Accumulated depreciation 16.96 28.09 Net fixed assets 261.61 361.90 Total Assets 527.61 734.30 Liabilities & owners equity Current liabilities Accounts payable 96.23 134.72 Short term loans payable 36.77 51.48 Total current liabilities 133.00 186.20 Long term liabiliites: Long term debt 236.33 327.81 Total liabiliites 369.33 514.01 Owner's equity Capital stock 113.08 165.35 Retained earnings 45.21 54.95 Total onwers equity 158.28 220.29 Total liabilites & owner's equity 527.61 734.30 Income Statement 2013 2014 Sales 980.00 1372.00 Cost of goods sold 726.60 1017.24 Gross margin 253.40 354.76 interest expense-Short term 1.40 2.65 Long term 17.73 22.57 operating expense-Depn 7.96 11.14 Others 217.00 303.80 income before tax 9.31 14.61 income tax 3.10 4.87 Net Income 6.21 9.74 Retained earnings opening balance 39.00 45.21 net income for the year 6.21 9.74 dividends 0 0 closing balance 45.21 54.95 Note: Capital stock is to be issued for both the years $63.08 for 2013 & $52.27 for 2014. With debt ratio of 95% HANDYMAN COMPANY ASSETS Current Assets Cash 14.00 19.60 Inventories 214.20 299.88 Accounts Receivable 37.80 52.93 Total Current Assets 266.00 372.40 Fixed Assets Property and equipment 278.57 389.99 Accumulated depreciation 16.96 28.09 Net fixed assets 261.61 361.90 Total Assets 527.61 734.30 Liabilities & owners equity Current liabilities Accounts payable 96.23 134.72 Short term loans payable 36.77 51.48 Total current liabilities 133.00 186.20 Long term liabiliites: Long term debt 368.23 511.39 Total liabiliites 501.23 697.59 Owner's equity Capital stock -15.31 -4.97 Retained earnings 41.69 41.69 Total onwers equity 26.38 36.72 Total liabilites & owner's equity 527.61 734.30 Income Statement 2013 2014 Sales 980.00 1372.00 Cost of goods sold 726.60 1017.24 Gross margin 253.40 354.76 interest expense-Short term 1.40 2.65 Long term 23.01 35.18 operating expense-Depn 7.96 11.14 Others 217.00 303.80 income before tax 4.03 1.99 income tax 1.34 0.00 Net Income 2.69 1.99 Retained earnings opening balance 39.00 41.69 net income for the year 2.69 0.00 dividends 0 0 closing balance 41.69 41.69 Note: Capital stock is to be repurchased for $65.31 during 2013 and reissued for $10.34 during 2004.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.