Can someone please help me prepare the Pro forma Income statement?
At the end of 2016, RMV's balance sheet was as follows: Rocky Mountain Vacations Ltd. Balance Sheet December 31, 2016 Current assets Cash CAD 600,000 Temporary investment 35,000 Accounts receivable 2 340,000 Inventory 1,748,400 Total current assets CAD 4,723,400 Fixed assets, net 3,954,300 Total assets CAD 8,677,700 Current liabilities Accounts payable CAD 1,425,000 Line of credit Current portion of long-term debt 461,300 Total current liabilities CAD 1,886,300 Long-term liabilities Term loan 2,306,500 Shareholders' equity Share capital 1,203,500 Retained earnings 3,281,400 Total liabilities and equity CAD 8,677 700 Sales The RV industry is very seasonal with most sales occurring in the second and third quarters. The second quarter is the busiest season as families get ready for summer holidays, but the third quarter remains strong as "snowbirds migrate" to their winter "nests" in California, Arizona, and Florida. Curtis has prepared the following sales estimates for 2017: Quarter 1 (January-March) Quarter 2 (April-June) Quarter 3 (July-September) Quarter 4 (October-December) 3 Models Freedom Independence Autonomy Total Service hours Storage units 5 16 18 39 590 50 11 33 81 125 910 30 9 25 65 99 13 16 32 530 50 920 25 North Star's three RV models cater to different price segments. Retail prices for 2017 are: Freedom Independence Autonomy CAD 165,200 CAD 137,800 CAD 85,500 Unit sales are expected to increase by 5.0% in 2018 but RMV has not raised its prices since adopting its new strategy in 2015. The dealer relations representative from North Star estimates that RMV could raise its prices by 2.0% with no change to the units sold. RMV's shop rate is CAD 70 per hour, which is low compared to the industry standard of CAD 90. All parts are resold at cost. Service work is paid for immediately by the customer. Twenty percent of all sales are for cash, but the remainder require financing. RMV offers customers three- and five-year financing plans, but these sales agreements are immediately resold to North Star's financing unit that repackages them and sells them as asset-backed securities. This process takes approximately 60 days, and RMV is paid in full at that time. The dealers have been lobbying North Star to reduce this payment period to 30 days through faster processing. RMV's fifty covered storage lots are rented at CAD 250 per unit per quarter, which RMW promotes as the "best rate in town." In the Kamloops market, rates for a similar unit averages CAD 500 per unit and the customer must commit to a one-year lease. Payment is received electronically from customers on the last day of each quarter. Cost of Sales The 2017 wholesale prices for North Star RVs are: Freedom Independence CAD 144,100 CAD 123,800 Autonomy CAD 74 200 The company's two mechanics are paid on piece rate and receive CAD 50 per service hour. Both mechanics are fully employed in quarters 2 and 3 but are underutilized the rest of the year. RMV has been exploring ways to improve efficiency in the service area. As engines in all three RV models are standard General Motors designs, parts can be sourced locally on a just-in-time basis, therefore, negligible parts inventories are required. Supply inventories are also minimal. For planning purposes, RMV finds that parts and supplies average 100.0% and 10.0% of service revenue. RMV purchases all of its RVs on terms net 30 from North Star. RMV maintains inventory levels at 40.0% of next quarter's sales for each model of RV. The dealer relations representative from North Star says other dealers maintain inventory of only 25.0% of next quarter's sales on average. The representative also indicates that North Star's credit terms are sometimes extended to net 60 to aid struggling dealers or help finance expansions. Beginning inventory consists of two Freedom models, seven Independence models, and eight Autonomy models. Wholesale prices were the same as in 2016. Other Expenses Category Selling Details Five sales staff at CAD 32,000 per employee per year plus a commission equal to 6.0% of RV sales CAD 950,000 per year CAD 285,000 per year Administration and storage Depreciation Other than inventory purchases and depreciation, all expenses are paid as incurred. RMV has been considering paying its sales staff on a straight commission basis to improve results. The number of salespeople will likely decline as poorer performers see their incomes drop, but the remaining sales people should be able to maintain their earnings. Capital Budget RMV has prepared a list of capital acquisitions that it plans to make in 2017: Item Service bay equipment - 10-year life Sales facility furniture - 3-year life Estimated cost CAD 850,000 CAD 75,000 Acquisition Date Quarter 1 Quarter 1 The equipment is needed to open the remaining two service bays and additional furniture is required for the sales offices. The equipment purchases can be delayed if necessary. All assets are depreciated on a straight-line basis and the residual value is assumed to be negligible. Financing RMV has negotiated a CAD 5,500,000,5.50% line of credit with the Royal Bank. The loan is secured by the company's current assets it can borrow no more than 50.0% of the value of its inventory and 70.0% of its accounts receivable. Interest is paid at the end of each quarter and all repayments or draw downs are made at that time. Purchases of fixed assets can be financed with a term or mortgage loan with the Royal Bank. The bank is willing to lend 60.0% of the value of equipment and 75.0% of the value of real estate. Loans are paid down monthly on a straight-line basis over the life of the asset and generally cannot be paid early. Asset acquisitions and interest and principal payments are made at the end of the quarter only. The term loan currently has a fixed interest rate of 7.50% per annum. The Royal Bank allows the company to make an additional principal payment equal to 20.0% of the balance of any term and mortgage loan at the end of the fourth quarter each year, The Royal Bank requires that RMV maintain a current ratio of 1.50 each quarter and an annual times interest earned ratio of 4.50 (i.e. it is only calculated in the fourth quarter based the yearly totals) as well as submit audited quarterly and annual financial statements for review. Also, the line of credit must be paid down to zero once per year to ensure the company only uses its line of credit to finance its seasonal build up in net working capital. RMV attempts to maintain a long-term debt to total-capitalization ratio of 25.00% although it is not a condition of any of its bank loans. Company policy is to maintain a cash balance of CAD 600,000 at the end of each quarter. Surplus cash balances can be invested in a 3-month term deposit at 1.50% per annum. Funds are invested or withdrawn at the end of the quarter only and income is paid out at this time. Based on past experience, the company was studying whether a cash balance of CAD 500,000 could be sufficient. Income Taxes The corporate tax rate is 15.0%. Corporate income tax installments of CAD 25,000 are paid at the end of each quarter. Distributions to Owner Current loan agreements limit Curtis' dividends to CAD 400,000 per year. RMV currently pays this amount to Curtis in four equal monthly installments, but she indicated it could be reduced to CAD 200,000 per year if necessary. At the end of 2016, RMV's balance sheet was as follows: Rocky Mountain Vacations Ltd. Balance Sheet December 31, 2016 Current assets Cash CAD 600,000 Temporary investment 35,000 Accounts receivable 2 340,000 Inventory 1,748,400 Total current assets CAD 4,723,400 Fixed assets, net 3,954,300 Total assets CAD 8,677,700 Current liabilities Accounts payable CAD 1,425,000 Line of credit Current portion of long-term debt 461,300 Total current liabilities CAD 1,886,300 Long-term liabilities Term loan 2,306,500 Shareholders' equity Share capital 1,203,500 Retained earnings 3,281,400 Total liabilities and equity CAD 8,677 700 Sales The RV industry is very seasonal with most sales occurring in the second and third quarters. The second quarter is the busiest season as families get ready for summer holidays, but the third quarter remains strong as "snowbirds migrate" to their winter "nests" in California, Arizona, and Florida. Curtis has prepared the following sales estimates for 2017: Quarter 1 (January-March) Quarter 2 (April-June) Quarter 3 (July-September) Quarter 4 (October-December) 3 Models Freedom Independence Autonomy Total Service hours Storage units 5 16 18 39 590 50 11 33 81 125 910 30 9 25 65 99 13 16 32 530 50 920 25 North Star's three RV models cater to different price segments. Retail prices for 2017 are: Freedom Independence Autonomy CAD 165,200 CAD 137,800 CAD 85,500 Unit sales are expected to increase by 5.0% in 2018 but RMV has not raised its prices since adopting its new strategy in 2015. The dealer relations representative from North Star estimates that RMV could raise its prices by 2.0% with no change to the units sold. RMV's shop rate is CAD 70 per hour, which is low compared to the industry standard of CAD 90. All parts are resold at cost. Service work is paid for immediately by the customer. Twenty percent of all sales are for cash, but the remainder require financing. RMV offers customers three- and five-year financing plans, but these sales agreements are immediately resold to North Star's financing unit that repackages them and sells them as asset-backed securities. This process takes approximately 60 days, and RMV is paid in full at that time. The dealers have been lobbying North Star to reduce this payment period to 30 days through faster processing. RMV's fifty covered storage lots are rented at CAD 250 per unit per quarter, which RMW promotes as the "best rate in town." In the Kamloops market, rates for a similar unit averages CAD 500 per unit and the customer must commit to a one-year lease. Payment is received electronically from customers on the last day of each quarter. Cost of Sales The 2017 wholesale prices for North Star RVs are: Freedom Independence CAD 144,100 CAD 123,800 Autonomy CAD 74 200 The company's two mechanics are paid on piece rate and receive CAD 50 per service hour. Both mechanics are fully employed in quarters 2 and 3 but are underutilized the rest of the year. RMV has been exploring ways to improve efficiency in the service area. As engines in all three RV models are standard General Motors designs, parts can be sourced locally on a just-in-time basis, therefore, negligible parts inventories are required. Supply inventories are also minimal. For planning purposes, RMV finds that parts and supplies average 100.0% and 10.0% of service revenue. RMV purchases all of its RVs on terms net 30 from North Star. RMV maintains inventory levels at 40.0% of next quarter's sales for each model of RV. The dealer relations representative from North Star says other dealers maintain inventory of only 25.0% of next quarter's sales on average. The representative also indicates that North Star's credit terms are sometimes extended to net 60 to aid struggling dealers or help finance expansions. Beginning inventory consists of two Freedom models, seven Independence models, and eight Autonomy models. Wholesale prices were the same as in 2016. Other Expenses Category Selling Details Five sales staff at CAD 32,000 per employee per year plus a commission equal to 6.0% of RV sales CAD 950,000 per year CAD 285,000 per year Administration and storage Depreciation Other than inventory purchases and depreciation, all expenses are paid as incurred. RMV has been considering paying its sales staff on a straight commission basis to improve results. The number of salespeople will likely decline as poorer performers see their incomes drop, but the remaining sales people should be able to maintain their earnings. Capital Budget RMV has prepared a list of capital acquisitions that it plans to make in 2017: Item Service bay equipment - 10-year life Sales facility furniture - 3-year life Estimated cost CAD 850,000 CAD 75,000 Acquisition Date Quarter 1 Quarter 1 The equipment is needed to open the remaining two service bays and additional furniture is required for the sales offices. The equipment purchases can be delayed if necessary. All assets are depreciated on a straight-line basis and the residual value is assumed to be negligible. Financing RMV has negotiated a CAD 5,500,000,5.50% line of credit with the Royal Bank. The loan is secured by the company's current assets it can borrow no more than 50.0% of the value of its inventory and 70.0% of its accounts receivable. Interest is paid at the end of each quarter and all repayments or draw downs are made at that time. Purchases of fixed assets can be financed with a term or mortgage loan with the Royal Bank. The bank is willing to lend 60.0% of the value of equipment and 75.0% of the value of real estate. Loans are paid down monthly on a straight-line basis over the life of the asset and generally cannot be paid early. Asset acquisitions and interest and principal payments are made at the end of the quarter only. The term loan currently has a fixed interest rate of 7.50% per annum. The Royal Bank allows the company to make an additional principal payment equal to 20.0% of the balance of any term and mortgage loan at the end of the fourth quarter each year, The Royal Bank requires that RMV maintain a current ratio of 1.50 each quarter and an annual times interest earned ratio of 4.50 (i.e. it is only calculated in the fourth quarter based the yearly totals) as well as submit audited quarterly and annual financial statements for review. Also, the line of credit must be paid down to zero once per year to ensure the company only uses its line of credit to finance its seasonal build up in net working capital. RMV attempts to maintain a long-term debt to total-capitalization ratio of 25.00% although it is not a condition of any of its bank loans. Company policy is to maintain a cash balance of CAD 600,000 at the end of each quarter. Surplus cash balances can be invested in a 3-month term deposit at 1.50% per annum. Funds are invested or withdrawn at the end of the quarter only and income is paid out at this time. Based on past experience, the company was studying whether a cash balance of CAD 500,000 could be sufficient. Income Taxes The corporate tax rate is 15.0%. Corporate income tax installments of CAD 25,000 are paid at the end of each quarter. Distributions to Owner Current loan agreements limit Curtis' dividends to CAD 400,000 per year. RMV currently pays this amount to Curtis in four equal monthly installments, but she indicated it could be reduced to CAD 200,000 per year if necessary
