Reference no: EM132842952

Question - Rachel Ebbett is the controller for New Age Battery Manufacturing (NABM) and she has been asked by her CFO to prepare the company's financial plan for the next five years.

NABM's income statement, statement of retained earnings and balance sheet for the year just ended are supplied as tabs IS2020, RE2020 and BS2020.

Sales of existing products are expected to increase by 5% annually. Raw materials is expected to start at 30% of sales but increase by 2% a year to 40% of sales at the end of 5 years. Labour costs are expected to remain at 15% of sales for all 5 years. Marketing costs are expected to increase by 2% in total next year and then increase by $15 million in the second year and a further $25 million in the third year and then remain at that level because of new products being introduced in years 2 and 3. The corporate tax rate is expected to be 42% of net income before tax for all 5 years.

NABM uses a declining balance depreciation policy. Equipment is depreciated at a rate of 20% while plant is depreciated at a rate of 10%. For planning purposes, Rachel has been advised to assume that normal plant additions for the five years will be $15,000 per year and normal equipment additions will be $25,000 per year for the five years. Note that these additions are referred to as normal because they do not include any additions as part of the new product launches detailed below. Assume full depreciation is taken in year of purchase. These "normal" purchases will be financed with short-term debt.

NABM is planning 2 major capital investments in the next five years. They are associated with the launch of two new products, Product A and Product B and are expected to happen in 2022 and 2023. The details are noted below. In order to maintain a capital structure close to 60% debt and 40% common equity, these major capital investments will be financed with 60% long term debt and 40% common share equity.

Rachel also received a memo from NABM's investment advisors with their analysis of market returns and forecasts for interest rates, both short term and long term rates and common share prices and forecasted dividends for both common and preferred shares. See chart below. Interest is variable on short term debt and fixed on long term debt based on the rate at the time of issue. To minimize short term interest expense and increase asset efficiency, any access cash beyond a year end balance of $40,000 will be used to pay down notes payable at the beginning of the next year.

NABM's current assets, accounts payable and accruals grow at the same rate as sales growth. Notes payable are mainly loans from NABM's line of credit and are used to finance any "normal" fixed asset purchases. NABM is required to pay $16 million of its long term debt annually.

As part of Rachel's financial plan development she has been asked to estimate NABM's value today considering comparables for 2020 and future cash flows. Some valuation relevant ratios for a major competitor and the average for the industry within which NABM operates have been provided below.

Required -

1. Complete a proforma income statement, balance sheet and cash flow statement and a ratio analysis for competitive valuation assessment using the ratios provided.

2. Perform some scenario analysis considering the impact if sales for each new product launch is 15% lower than estimated and 10% higher than estimated. NABM's new products are related to the electric vehicle battery industry. Also consider what happens if there is a shortage in raw materials and as a result all raw material costs related to the product launches are 20% higher than originally estimated. (3 alternate scenarios in total)

3. What do you estimate NABM's value to be today and how do you come to that conclusion (use at least 2 different valuation techniques used in Ch. 22 to support your conclusions)?

4. As controller, write a report to the CFO summarizing your significant findings from the 5 year financial plan development. Make sure to reference work done in items 1,2 and 3 above.