REQUIRED:	Valuing a company in the EV sector
Consider the financial data below for Piper Inc. and use 4 different methods to impute a value for the company (as off a current date i.e., late April/early May 2024). The company pays a dividend each year and for 2022 onward, this must be computed and shown below (think balancing the balance sheet). Decide (and detail) why the company needs to be valued and based on this, assess and justify which method (and valuation) is most likely to 'hold-up' under scrutiny. In addition, based on your projected value, the price the most recent shares sold for, the most recent share prices etc. estimate and include amounts for 'Common Stock' for 2024. 2025 and 2026 and complete the 'mini' financial statements. Please note that all figures are in 000s except for the share price.
			Actual	Projected
	Account Description/Year	2021	2022	2023	2024	2025	2026
	Cash	25,141	25,639	32,977	34,000	50,000	32,000
	Accounts Receivable	272,450	312,776	368,267	420,000	480,000	570,000
	Prepaids	3,982	4,402	5,037	5,250	5,500	5,750
	Inventories	183,722	208,623	222,128	260,000	300,000	400,000
	Property & Equipment (net)	47,578	49,931	55,311	62,000	78,000	91,500
	Other Assets	18,750	20,750	23,750	26,000	36,250	40,000
	Accounts Payable	49,831	64,321	70,853	81,000	95,000	80,000
	Accrued Expenses	86,087	102,650	113,732	132,000	143,000	156,000
	Notes Payable	99,539	118,305	182,132	245,000	240,000	390,000
	Long-term Debt	62,622	43,251	35,407	32,000	128,000	127,000
	Deferred Taxes Payable	7,551	7,941	8,286	8,500	9,500	12,000
	Other Liabilities	5,279	5,521	5,697	5,500	5,250	4,750
	Common Stock	73,253	102,542	102,542
	Retained Earnings	167,461
	Net Sales	982,250	1,095,000	1,214,500	1,275,000	1,380,000	1,670,000
	Cost of Goods Sold	669,560	739,459	817,671	840,000	930,000	1,125,000
	Depreciation Expense	8,303	8,380	8,972	9,600	10,600	12,000
	Interest Expense	11,248	13,146	14,919	19,000	16,500	21,250
	Income Tax Expense	26,650	34,000	38,000	32,800	26,500	25,750
	Net Income
	Number of common shares outstanding at year-end	12,817	13,714	13,714	14,250	14,750	15,500
	Market price per share	38	43	49