Following a macro and micro forecast of sales/revenues and costs based on a number of key sources of information such as: historical income statements and balance sheet reports, trends within AntartiK Inc.s industry, the Consumer Discretionary Goods industry (including time, scale, and risk of firms revenue) AntartiK, Inc., a direct competitor to Tesla motors, demonstrates the volatile, cyclical, and highly competitive nature of AntartiKs focus on renewable energy, storage and innovative automobile manufacturing.

The Weighted Average Cost of Capital for AntartiK Inc. is 13%. The long term growth rate starting in Year 5 and thereafter is forecasted to be 10.5%, due to high demand for this innovative companys products. The company currently holds $8,000,000 in debt instruments, as valued by the market. AntartiK, Inc. has also recently issues a second round of a common shares offering bring the current level of 1,155,000 share outstanding. The corporate tax rate is at 30% for AntartiK, Inc.

A) What is the value per share?

B) If the market price is presently $150.00 per share is the company under or overvalued?

Please provides all the steps as detailed as possible

1. Calculate the free cash flow amounts for years 1 to 5, using the line #s and displayed formulas (such as Free cash flow(Lines 8 + 5 9 10).
2. Discount (take the present values of) these forecasted FCF streams in years 1-4, and then the Horizon Value (H_(T+1=5)/WACC g) also at Year 4. The Horizon value should be discounted separately at [1/ (1 + WACC) ^4](it can be done together as on page .
3. Then sum both discounted or present values, including the stream of FCF Years 1-4, and the Horizon Value discounted from year 4. The total will represent NTs total implicit firm valuation.
4. Then the next step is to transform total firm valuation into a per share basis.

Year 1 Sales 2 Cost of goods sold 3 Other costs 4 EBITDA (1-2-3) 5 Depreciation 6 Profit before tax (EBIT) (4-5) 7 Tax 8 Profit after tax (6-7) 0 $49,464 23,507 9,709 16,248 5,678 10,570 3,171 7,399 1 $67,332 41,560 10,680 15,092 5,890 9,202 2,761 6,441 2 $25,003 7,765 5,027 12,211 5,670 6,541 1,962 4,579 3 $44,135 15,459 8,613 20,063 5,908 14,155 4,247 9,909 4 $72,499 43,631 14.311 14,557 6,107 8,450 2,535 5,915 5 $95,050 58,957 17,173 18,920 5,908 13,012 3,904 9,108 9 Change in working capital 10 Investment (chg. in gross fixed assets) 781 6,554 -56 7,347 -352 5,340 -242 5,479 227 6,423 239 6,591 Free cash flow(8 + 5 - 9-10) $5,742.00 $5,040.40 $5,260.70 $10,579.50 $5,372.00 $8,186.40 PV Free cash flow, years 1-4 Horizon Value PV Horizon value Debt Part A) PV of company Value per share for NT, Inc. Part B) If the market price is presently $150.00 per share, is the company under or overvalued, when compared to market? Comments: The cells in yellow need to be solved for. I have adjusted and made appropriate changes to debt and shares outstaning. (you don't need to do this anymore, as I adjusted the amounts for debt and outstanding common shares Whenexamining the underlying excel based formulas for multyplying byoutstanding debt, and dividing by outstanding #of shares, you'll notice they are both multiplied by 0.001, which is justa mannerof coverting a figure in millionstothousands, to make for working onalevel playing field, or all numeration alike. The general formula for solving for free cash flow (FCF), if you choose to use MS Excel to solve for nart of this nroblem are found in cell B231ine 8+5.9-101 hence voul