Only need the last part of the project--the equity valuation and the memo done please. Attached is...

Question

Only need the last part of the project--the equity valuation and the memo done please. Attached is the exemplar and the assignment

Ford Valuation, i Ford Motor Company Valuation FISV 5526: Financial Reporting and Control Professor David Cartwright May 2016 Ford Valuation, ii Table of Contents General Information 1 Short Term Liquidity 1 Capital Structure and Solvency 2 Asset Utilization 3 Profitability 4 Equity Valuation 4 Memorandum 7 References 8 Appendices 1.1 Current Ratio 9 3.1 Net Operating Asset Turnover 10 4.1 Profit Margin and Return on Net Operating Assets 13 5.1 Ford Motor Company Historic Sales and ∆Sales 14 Ford Valuation, 1 General Information For the entirety of the following analysis of Ford Motor Company versus General Motors, individual company data was extracted from the most recent and respective 10-K documents filed with the United States Securities and Exchange Commission (SEC). Industry ratios and data were extracted from ‘Stock Analysis on Net’ via the url: www.stock-analysis-on-net.net/ Short Term Liquidity A current ratio is designed to measure short term liquidity by dividing Current Assets by Current Liabilities. At a glance, the ratio can indicate whether or not a company will be able to “service its debt in the short run” (Easton et al., 3-20). A company with a ratio of 1.0 is said to have enough current assets to pay short term debt. A ratio lower than one indicates a company may have trouble paying short term debt, and a ratio higher than 1.0 may indicate a company is being too frugal with its assets and could take more risks or make more investments in the future. As of the end of Fiscal Year 2015, Ford Motor Company’s current ratio is 0.9 and General Motors’ current ratio is 1.09; industry average is 1.09. These numbers indicate both companies have good liquidity though General Motors may be a little better off than Ford. Ford having a ratio slightly less than 1.0 indicates that differences in inventory levels might explain ratio difference (Easton et al., 4-15). Table 1.1: Current Ratio Current Assets Current Liabilities Current Ratio *Ford $73,754 $81,764 0.90 GM $78,007 $71,466 1.09 Industry 1.09 *See Appendix 1.1: Current Ratio A quick ratio measures cash plus marketable securities plus accounts receivable, all over current liabilities. This ratio gives readers another way to view liquidity by excluding inventories and prepaid assets (Easton et al., 4-16). As of the end of Fiscal Year 2015, Ford Motor Company’s quick ratio is 1.68 and General Motors’ ratio is 0.44; industry average is 0.72. In contrast with results from the current ratio, the quick ratio indicates Ford is actually more liquid than General Motors. As mentioned above, a possible explanation for the drastic difference in the results from these two ratios is the differing inventory levels between the two companies. http://www.stock-analysis-on-net.net/ http://www.stock-analysis-on-net.net/ Ford Valuation, 2 Table 1.2: Quick Ratio Cash Marketable Securities Accounts Receivable Quick Ratio Ford $14,272 $20,904 $101,975 1.68 GM $15,238 $8,163 $8,337 0.44 Industry 0.72 Between the two different measures of liquidity for both Ford Motor Company and General Motors, both companies seem to be safe short term investments with key differences lying in inventory values and prepaid assets, with no clear distinction as to which company would make for a better investment. Capital Structure and Solvency The total debt to equity ratio equals all long term debt plus all short term debt, divided by stockholders’ equity. This ratio is a measure of solvency, indicating whether or not a company can generate sufficient cash to repay long term obligations (Easton et al., 3-20). The higher a company’s total debt to equity ratio, the riskier investment a stockholder is making. These ratios should be considered in context of industry, however, and therefore can differ dramatically from one industry to the next. Ford Motor Company and General Motors both hold more debt than equity. Table 2.1: Total Debt to Equity Ratio Long term Debt Short Term Debt Stockholders’ Equity Total Debt to Equity Ratio Ford $120,731 $13,902 $28,657 4.70 GM $43,549 $19,562 $39,871 1.58 Industry 2.86 Ford’s debt to equity ratio is three times General Motors’ ratio, and roughly 1.5 times that of the industry indicating the company relies more heavily on debt financing than most competitors. Table 2.2: Operating vs Non-Operating Return ROE RNOA Non-Operating Return Ford 27.8% 7.9% 19.8% GM 25.2% 16.2% 9.0% Industry 24.9% Ford Valuation, 3 Table 2.3: Debt to Assets Ratio Total Assets Debt to Assets EBIT Interest Expense Ford $224,925 0.60 $11,025 $773 GM $194,520 0.32 $8,161 $443 Industry 0.74 Table 2.4: EBITDA Coverage Ratio Depreciation + Amortization EBIT Interest Expense EBITDA Coverage Ratio Ford $7,993 $11,025 $773 25.60 GM $8,017 $8,161 $443 37.52 Industry Table 2.5: Liabilities to Equity Ratio Total Liabilities Stockholder's Equity Liabilities to Equity Ratio Ford $196,174 $28,657 6.85 GM $154,197 $39,871 3.87 Industry Asset Utilization Asset utilization examines the company’s revenues in relation to their dollar assets. We calculate Net Operating Asset Turnover (NOAT) by dividing the company’s sales with their average Net Operating Assets. Asset utilization builds into the Parsimonious method of multiyear forecasting for a company by using both net operating profit margins (in the next section) and NOAT. Asset utilization represents how optimized a company’s assets are toward producing sales. If a company has a NOAT of 1.0, then every dollar earned is a result of a single dollar of an asset. This is not the ideal for a company as producing more in sales per dollar would show a better use of assets. Therefore, a higher NOAT is desirable. Ford has a 1.25 NOAT, while GM has a much higher 2.50. This predicts that Ford will not see as high a return on their assets as GM. Table 3.1: Net Operating Asset Turnover Sales *Average NOA Net Operating Asset Turnover Ford $149,558 $119,629 1.25 GM $152,356 $60,882 2.50 Industry *See Appendix 3.1 Ford Valuation, 4 Profitability Profitability may be determined through an examination of profit margin, return on net operating assets, and return on equity. Profit margin is calculated by dividing Net Operating Profit after Taxes (NOPAT) by Sales. Return on Net Operating Assets (RNOA) is calculated by dividing NOPAT by the Average Net Operating Assets. As predicted with the NOAT ratio, Ford has a smaller RNOA than GM, indicating that they are not as efficient in their asset utilization. Table 4.1: Profit Margin and Return on Net Operating Assets NOPAT Profit Margin RNOA Ford $9,469 6.3% 7.9% GM $9,835 6.5% 16.2% Industry 6.0% *See Appendix 4.1 Return on Equity is calculated by dividing net income by average equity and is a combination of the return on both operating and non-operating activities. A higher ROE is an indicator of high growth within a company. Ford shows a 2.9% higher ROE than the industry and 2.6% higher than GM, indicating that Ford is using its shareholder’s money to generate more profit. Table 4.2: Return on Equity Net Income Average Equity ROE Ford $7,371 $26,561 27.8% GM $9,615 $38,174 25.2% Industry 24.9% Equity Valuation Equity valuation is used to determine the value of the company along with their assets. It helps decide their stock margins as well as their assets. There are numerous ways to calculate the equity valuation as there are different categories in which one can form a determination. Once internal equity valuation is determined it can be compared with competition as well as prior company history. Equity valuation upon growth: Growth = Return on Equity x amount of earnings / dividends Growth = ROE x Plowback Growth Ford = 2.2 x (1.84/0.15) Growth Ford = 2.2 x 12.27 Growth Ford = 26.99 Growth GM = 1 x (5.91/2.2) Growth GM = 1 x 2.69 Growth GM = 2.69 Ford Valuation, 5 Industry's current growth has been decreased from the average 3.1 to 1. The numbers provided from the 10K report show a surprising spike for Ford versus GM. Although they are both American companies, Ford may have new innovations along with additional supplies that are non-automotive items that

groupprojectexemplar-fisv5526-3okafyfn.pdf 10k-draft-3-fklc0fai-tpydnh2s.docx

Neenisha · Accepted Answer

Balance Sheet
		Consolidated Balance Sheets - USD ($) $ in Millions	Dec. 31, 2015	Dec. 31, 2016		Dec. 31, 2017	Dec. 31, 2018	Dec. 31, 2019		Growth %		2020	2021	2022	2023	2024
		Current Assets:
		Cash and cash equivalents	$ 538	$ 403		$ 570	$ 1,418	$ 609
		Restricted cash and cash equivalents	92	81		100	266	247
		Accounts receivable, net of allowance for doubtful accounts	1,261	1,150		998	1,005	876
		Inventories					541	442
		Current portion of financing receivables, net					138	129
		Prepaid expenses	130	160		111	137	147
		Income taxes receivable	72	189		36	13	97
		Other				171	39	38
		Current assets of discontinued operations				0
		Total current assets	2,093	1,983		1,986	3,557	2,585		4.31%		2696	2813	2934	3061	3193
		Intangibles and Other Assets:
		Goodwill	5,159	5,160		5,190	5,822	5,887
		Brands	4,877	4,869		4,890	4,848	4,919
		Management and franchise contracts, net	780	872		909	507	586
		Other intangible assets, net	421	415		433	1,133	2,036
		Operating lease right-of-use assets	867	0		353	963	887
		Property and equipment, net	380	367		113	8,930	9,119		2.12%		9312	9509	9710	9916	10126
		Deferred income tax assets	100	90		434	117	78
		Other	280	239		0	334	274
		Total intangibles and other assets	12,864	12,012		12,322	22,654	23,037
		Total assets	14,957	13,995		14,308	26,211	25,622
		Current Liabilities:
		Accounts payable, accrued expenses and other	1,703	1,549		2,150	2,453	2,206
		Current maturities of long-term debt	37	16		46	98	94
		Current portion of deferred revenues	332	350		12	73	110
		Income taxes payable					60	33
		Total current liabilities	2,871	2,615		0	2,684	2,443		-3.18%		2495	2548	2601	2656	2713
		Long-term debt	7,956	7,266		2,208	10,020	9,857		4.38%		10066	10279	10496	10718	10945
		Operating lease liabilities	1,037	0		6,556	621	392
		Deferred revenues	827	826		97	64	283
		Deferred income tax liabilities	795	898		1,063	4,575	4,630
		Other	883	863		839	889	784
		Other				1,470	1,509	1,282
		Total liabilities	15,429	13,437		12,233	20,362	19,671
		Commitments and contingencies	 	 		 
		Equity (Deficit):
		Preferred stock	0	0		0	0	0
		Common stock	3	3		3	10	10
		Treasury stock, at cost	(4,169)	(2,625)		(891)
		Additional paid-in capital	10,489	10,372		10,298	10,213	10,151
		Accumulated deficit	(5,965)	(6,417)		(6,596)	(3,323)	(3,392)
		Accumulated other comprehensive loss	(840)	(782)		(742)	(1,001)	(784)
		Total Hilton stockholders' equity (deficit)	(482)	551		2,072	5,899	5,

Ford Valuation, i Ford Motor Company Valuation FISV 5526: Financial Reporting and Control Professor David Cartwright May 2016 Ford Valuation, ii Table of Contents General Information XXXXXXXXXX Short...

Answer To: Ford Valuation, i Ford Motor Company Valuation FISV 5526: Financial Reporting and Control Professor...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment

Sun	Mon	Tue	Wed	Thu	Fri	Sat
30	31	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	1	2	3