This is for help with Milestone One. Attached is the rubric as well as the required excel template. For the company, it has to be either Apple or Samsung. Thanks!

FIN 330 Final Project I Milestone One Guidelines and Rubric Overview: Corporate financial managers must have a business-wide perspective to successfully navigate the corporate environment. The skills you develop in this course will support you in your future business career as well as set the foundation for the concepts that will be covered in the next course, FIN 336: Multinational Corporate Finance. Your final projects for FIN 330 will allow you to showcase your mastery of the varied skills a finance professional must obtain by requiring you to analyze a real-world corporation from a quantitative perspective while also investigating the challenges and decisions a manager must face. As such, your assessment will be broken up into two separate but related final projects. The first project, a corporate valuation report, will focus on a U. S. corporation of your choice. You will analyze the historical financials of your chosen corporation, using the provided Excel template, and estimate the value of your corporation in a brief report. The second project is a risk management and ethical analysis report, which will focus on the same corporation, highlighting the management and leadership considerations and decisions required of top-level financial managers. In this written report, you will discuss ethics, corporate social responsibility, and challenges related to attaining short-term and long-term goals. Combined, these two projects will assess your learning regarding the quantitative and qualitative concepts of corporate finance and leadership. Prompt: This milestone requires you to write a draft of the Overview and Financial History sections (Sections I and II) of Final Project I, the corporate valuation report. This milestone requires you to select and focus on a specific corporation of interest for the larger final projects. To support your selection, you are encouraged to use Mergent Online. Refer to the provided Mergent Online Instructions for assistance in navigating Mergent Online. Specifically, the following critical elements must be addressed in this milestone: I. Overview: This section of your report will be devoted to providing a thorough overview of the background of the corporation you selected and setting the foundation for your later discussion of the challenges financial managers face. Specifically, you must address the following: A. Describe the market to which your corporation belongs, identifying the products or services your corporation sells, and the share of the market it has. B. Describe the customer base of your corporation and the top competitors for this customer base. Be sure to consider what motivates the customers and the challenges the organization faces in retaining the customer base. C. Describe the key inputs and sources of those inputs used to create the products or services as well as the key resources for corporate operation (such as staff, facilities, technologies, etc.) and the extent to which attaining all these resources presents a challenge to the particular organization. D. Analyze key market trends and issues within the industry for potential risks to the organization. II. Financial History: The next section of your report should focus on the financial history and capital structure of your organization. A. Quantitatively analyze three years of the corporation's finances using the provided Excel template. You will submit this template along with your report, and may embed pieces of the Excel template into your report to show key financial highlights for the following section. Please note that, for this assignment, you only need to complete the \"Financial History\" tab in the spreadsheet. B. Summarize the financial highlights you determined from the analysis in the Excel template, explaining the significance of the key ratios for the overall financial health of the organization. Guidelines for Submission: Your Overview and Financial History should be 3-4 pages in length, not including the Excel template you use to address section II.A, above. The written submission should use 12-point Times New Roman font, double spacing, one-inch margins, and APA formatting. Be sure to submit both your written response and the completed Excel template when submitting this assignment. Any citations should follow APA guidelines. Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions. Critical Elements Overview: Market Overview: Customer Proficient (100%) Accurately describes the market, products or services, and portion of the market held by the chosen corporation Accurately describes the customer base and the corporation's top competitors for those customers Overview: Resources Accurately describes the key inputs and resources the corporation needs Overview: Trends Critically analyzes the market for key trends and issues that may pose risks for the corporation Financial History: Excel Correctly analyzes three years of corporate financial statements using the provided Excel template Needs Improvement (80%) Describes the market, products or services, and portion of the market held by the chosen corporation, but lacks accuracy or necessary detail Describes the customer base and the corporation's top competitors for those customers, but lacks accuracy or detail Describes the key inputs and resources the corporation needs, but lacks accuracy or detail Analyzes the market for key trends and issues, but lacks detail, logic, or focus on issues that may pose risks for the corporation Analyzes three years of corporate financial statements using the provided Excel template, but analysis contains miscalculations or is incomplete Not Evident (0%) Does not describe the market, products or services, and portion of the market held by the chosen corporation Does not describe the customer base and the corporation's top competitors Value 13 14 Does not describe inputs and resources the corporation needs 15 Does not analyze the market for trends and issues 13 Does not analyze three years of corporate financial statements using the provided Excel template 20 Financial History: Highlights Articulation of Response Accurately summarizes the financial highlights determined from the Excel analysis of the corporate financial statements, citing key ratios that give a picture of the overall financial health Submission has no major errors related to citations, grammar, spelling, syntax, or organization Summarizes the financial highlights determined from the Excel analysis of the corporate financial statements, but lacks accuracy or details regarding key ratios that give a picture of the overall financial health Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas Does not summarize the financial highlights determined from the Excel analysis 20 Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas 5 Total 100% [COMPANY'S FULL NAME] INCOME STATEMENT HIGHLIGHTS Unaudited; Amounts USD x 1000 For Fiscal Years ended [Month] [Day] % Growth vs Prior Year 2016 2015 2014 2016 2015 TOTAL REVENUE $ - $ - $ - 0.0% 0.0% Cost of Goods Sold Gross Profit or (Loss) $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Other Operating Expenses OPERATING INCOME $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Interest Income or (Expense), Net $ - $ - $ - 0.0% 0.0% Other Income or (Expense), Net Income before Tax Provision $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Provision for Income Taxes Net Income or (Loss) from Continuing Operations $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Discontinued Operations Income (Loss), Net NET INCOME OR (LOSS) $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Average Diluted Shares Outstanding DILUTED EARNINGS OR (LOSS) PER SHARE $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Net Income Margin % Common Stock Share Price at each Year-End Total Equity Value (= share price x shares) Price / Earnings Ratio (P/E) $ $ 0.0% 0.0% 0.0% 0.0% 0.0% $ $ - 0.0% $ $ - 0.0% - Source: [Title (Date). Retrieved from http://www.?????????????? qattachments_d2de259d54b5fd7285307056c1624451bbbd0009.xlsx Printed 06/06/2017 Page 1 of 10 [COMPANY'S FULL NAME] CASH FLOW STATEMENT HIGHLIGHTS Unaudited; Amounts USD x 1000 For Fiscal Years ended [Month] [Day] % Growth vs Prior Year 2016 2015 2014 2016 2015 Net Income or (Loss), from Above $ - $ - $ - 0.0% 0.0% Depreciation and Amortization Expense $ - $ - $ - 0.0% 0.0% Other Operating Sources and (Uses) Cash Flow from Operating Activities $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% (Capital Expenditures, Net of Disposals) $ - $ - $ - 0.0% 0.0% Other Investing Activities Cash Flow from Investing Activities $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Increase or (Decrease) in Debt (Dividend Payments) $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Other Financing Activities Cash Flow from Financing Activities $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Cumulative Translation Adjustment NET CASH FLOW $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Memo: Free Cash Flow $ - $ - $ - 0.0% 0.0% Source: [Title (Date). Retrieved from http://www.?????????????? qattachments_d2de259d54b5fd7285307056c1624451bbbd0009.xlsx Printed 06/06/2017 Page 2 of 10 [COMPANY'S FULL NAME] BALANCE SHEET HIGHLIGHTS Unaudited; Amounts USD x 1000 For Fiscal Years ended [Month] [Day] % Growth vs Prior Year 2016 Current Assets Cash and Marketable Securities Accounts Receivable, Net All Other Current Assets Total Current Assets Non-current Assets Property, Plant and Equipment, Net Goodwill and Other Intangible Assets Other Non-current Assets 2015 2014 $ $ - $ $ - $ $ - $ $ - $ $ - $ $ - $ $ - $ $ - $ $ - 2016 2015 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% $ - $ - $ - Total Non-current Assets TOTAL ASSETS $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Current Liabilities Accounts Payable, Net $ - $ - $ - $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% $ - $ - $ - $ - $ - $ - 0.0% 0.0% 0.0% 0.0% $ $ - $ $ - $ $ - 0.0% 0.0% 0.0% 0.0% Common Stock, at par Additional Paid-in Capital Retained Earnings $ $ $ - $ $ $ - $ $ $ - CTA and Other TOTAL SHAREOWNERS' EQUITY $ $ - $ $ - $ $ - Other Current Liabilities Total Current Liabilities Non-current Liabilities Long-term Debt Other Non-current Assets Total Non-current Liabilities TOTAL LIABILITIES SHAREOWNERS' EQUITY Source: [Title (Date). Retrieved from http://www.?????????????? qattachments_d2de259d54b5fd7285307056c1624451bbbd0009.xlsx Printed 06/06/2017 Page 3 of 10 [COMPANY'S FULL NAME] SELECTED FINANCIAL RATIOS Unaudited; Amounts USD x 1000 For Fiscal Years ended [Month] [Day] % Growth vs Prior Year FINANCIAL RATIOS Price / Earnings Ratio Debt / Equity Ratio Return on Equity (ROE) % Return on Assets (ROA) % Net Profit Margin % Free Cash Flow OTHER USEFUL RATIOS Earnings per Share or EPS Current Ratio Days Sales Outstanding (DSO) COMMON STOCK PRICE Adjusted Close Price on or near [Month] [Day] $ $ $ 2016 2015 2014 2016 2015 0.0 0.0 0.0% 0.0% 0.0% $ 0.0 0.0 0.0% 0.0% 0.0% $ 0.0 0.0 0.0% 0.0% 0.0% - 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% $ 0.0 0 - $ 0.0 0 $ 0.0 0 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% - $ - 0.0% 0.0% 2016 - Pct Change 0.0% RATE OF RETURN CALCULATIONS 2013 2014 2015 Adjusted Close Price at fiscal End of Year (EOY) $ $ Annual Dividends per Share $ $ $ If you buy 1 share at end of fiscal 0, collect dividends, then sell at end of fiscal 2016, your 3-year percent gain would be: BUT WHAT IF WE VIEW THIS AS A TIME VALUE OF MONEY QUESTION? Investor's Annual Cash Flow for 1 Share $ Solve for the annual Internal Rate of Return or IRR, with N=3 Yrs $ - $ - $ 0.0% Err:523 Source: [Title (Date). Retrieved from http://www.?????????????? qattachments_d2de259d54b5fd7285307056c1624451bbbd0009.xlsx Printed 06/06/2017 Page 4 of 10 [COMPANY'S FULL NAME] CAPITAL STRUCTURE For End of Fiscal Year 2016 Unaudited; Amounts USD x 1000 SIMPLE METHOD Debt: Bank Loans Debt: Bonds Debt: Commercial Paper Debt: Other or Unidentified Leases (a form of Debt) Preferred Stock (if any) Common Stock: At Par Common Stock: Add'l Paid-in Capital Retained Earnings [Other] Cost of Capital: Estimated % Capital Funding Return Req'd Amount by Investors $ 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% TOTAL $ TEXTBOOK METHOD Corporate Marginal Tax Rate % 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 1 - Corp Tax Rate 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% $ Cost of % Cost of Capital per Year Capital, After (Column C x Tax Savings Coumn G) 0.0% $ 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% - - ? $ - Wgt x Cost #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! % of Total #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! WEIGHTED AVERAGE COST OF CAPITAL: WACC = [$ Total Annual Cost of Capital] / [$ Total Capital Funding] = $0 / $0 TOTAL DEBT AND EQUITY Total Debt, incl. Leases & Preferred Stock Pct of Total 0.0% So Debt/Equity Ratio = - - 0.0% And Debt/Total Capital Ratio = - - 0.0% Amount - Total Equity, incl "Other" TOTAL $ qattachments_d2de259d54b5fd7285307056c1624451bbbd0009.xlsx Capital Structure Printed 06/06/2017 = #DIV/0! Page 5 of 10 [COMPANY'S FULL NAME] - COMPANY VALUATION 2016 2017 2018 (Unaudited; USD 1000) 2019 2020 2021 2022 2023 2024 2025 2026 Total 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0 Interest & Other Income (Exp) PRETAX INCOME OR (LOSS) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Tax Provision Discont'd Ops Income (Loss) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 - 0 0 - 0 0 - 0 0 - 0 0 - 0 0 - 0 0 - 0 0 - 0 0 - 0 0 - 0 0 - 0 Fiscal Year --> REVENUE Growth Rate vs Prior Year Total Operating Expenses OP INCOME OR (LOSS) Operating Margin NET INCOME OR (LOSS) Diluted Avg Shares DILUTED EPS Net Income or (Loss), from Above Deprec'n & Amortiz'n Expense $ $ $ $ $ $ $ $ $ $ $ $ - Other Op Sources & (Uses) Cash Flow from Op Activities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (Capital Expenditures, Net of Disposals) Other Investing Activities Cash Flow from Invest'g Activities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Increase or (Decrease) in Debt (Dividend Payments) Other Financing Activities Cash Flow from Financ'g Activities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cumulative Translation Adjustment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NET CASH FLOW Memo: Free Cash Flow qattachments_d2de259d54b5fd7285307056c1624451bbbd0009.xlsx Valuation Printed 06/06/2017 Page 6 of 10 [COMPANY'S FULL NAME] - COMPANY VALUATION Fiscal Year --> 2016 2017 2018 0 0 0 (Unaudited; USD 1000) 2019 2020 2021 2022 2023 2024 2025 2026 Total 0 0 0 0 0 0 0 VALUATION CALCULATIONS NET CASH FLOW "NCF" NET PRESENT VALUE OF FUTURE CASH FLOWS NPV @ 5.0% $ NPV @ 10.0% $ NPV @ 18.0% $ 0 0 0 For low-risk companies. The value here is what you would be willing to pay to buy the company under these assumptions. 0 For medium-risk companies. The value here is what you would be willing to pay to buy the company under these assumptions. 0 For high-risk companies. The value here is what you would be willing to pay to buy the company under these assumptions. If you had bought the whole company at the end of fiscal 2016 for its actual market value of ---> Net Cash Flow w/ Investment Cumulative NCF Cash Flow Payback Period Internal Rate of Return 0 0 #DIV/0! Years Err:523 IRR 0 0 $0 (From Financial History worksheet) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 After that many years, the cumulative cash flow turns positive. (It could turn negative again in one or more future years.) At this discount rate R, the NPV will equal $0. IRR is a bit dangerous, because there can be more than one solution. 0 MODIFIED INTERNAL RATE OF RETURN (MIRR) Financing Rate 0.0% COSTS (Negative) Initial Investment, if any $ Regular operating costs Ending shutdown or cleanup costs Opportunity cost Cannibalization (if any) Other costs (excl sunk costs) BENEFITS (Positive) New sales revenue Add'l sales of existing stuff Cost savings TOTAL For R= 0 (5,000) $ 1 - $ (100) (25) (10) 50 5 2 - $ (100) (25) (12) 300 10 3 - $ (100) (25) (15) 500 10 Other incremental benefits NET CASH FLOW $ (5,000) $ (80) $ 173 $ 370 $ 10.00% NPV ($2,970) Note: "R" should be the risk-adjusted required rate of return for an investment of this estimated level of risk. It is usually between 3.0% and 20%. 4 - $ (100) (25) (15) 600 10 470 $ NOTE: Extend timeline for however m 5 6 - $ (100) (100) (25) (25) (15) (15) 600 600 10 10 470 $ 470 Note: Projections of future cash flows are almost always highly uncertain. Consider different scenarios, such as most likely, best case, and worst case. qattachments_d2de259d54b5fd7285307056c1624451bbbd0009.xlsx Printed 06/06/2017 Page 10 of 10