FIN 320 Milestone Two In need of help for the assignment. I have all the data for the assignment i just need someone to answer the questions for the writte

FIN 320 Milestone Two In need of help for the assignment. I have all the data for the assignment i just need someone to answer the questions for the written analysis using the data provided. 

Competencies
In this project, you will demonstrate your mastery of the following competencies:

Analyze financial and investment decisions that add value to the organization
Analyze financing options to maximize investor value

Scenario
You are a financial analyst for the chosen business that you selected during your Module Two Journal assignment. Your supervisor has discovered last minute that your business’s board of directors is looking for updates on the business’s financial health. Your supervisor has asked you to write a report regarding the business’s current financial health and the available financial options for improving the business. You’ve also been asked to make recommendations as to which options the business should choose to best support its financial health. Your supervisor will then use your report to present to the business’s board of directors, whose members all have varying levels of knowledge in terms of finance.
Directions
Using the business you chose from the Project Two Business Options List, create a report for your supervisor to share with the board of directors during their presentation. Keep in mind that your report needs to be easy for someone unfamiliar with finance to understand, as not all of the board members for your business fully understand finance.
Using Mergent Online, locate the most recent quarterly financial statements for your chosen company, and use these statements to support your analysis throughout the project. Refer to the Project Two Financial Assumptions document located in the Supporting Materials section for the assumptions you need in order to analyze the three available financial options outlined in the Financial Analysis section of the project directions.
You are encouraged to use the Project Two Financial Analyst Report template located in the What to Submit section to help complete this project.
Specifically, you must address the following:

Financial Analysis: In this section of the report, you will use the most recent quarterly financial statements for your chosen business and the Project Two Financial Formulas spreadsheet (located in the What to Submit section) to calculate appropriate financial formulas for assessing the business’s financial health. You will also analyze all three available financial options for improving the business based on your calculations and the provided Project Two Financial Assumptions document.

Financial Calculations: Calculate accurate financial formulas to assess the business’s current financial health. Specifically, you must calculate the following:

Working capital
Current ratio
Debt ratio
Earnings per share
Price/earnings ratio
Total asset turnover ratio
Financial leverage
Net profit margin
Return on assets
Return on equity

Working Capital Management: Explain the impact of working capital management on the business’s operations. Provide examples to support your claims.
Bond Investment: Analyze the risks and benefits of the business choosing to invest in a corporate bond, including the necessary ethical considerations, appropriate calculations, and examples to support your analysis.
Capital Equipment: Analyze the risks and benefits of the business choosing to invest in capital equipment, including the necessary ethical considerations, appropriate calculations, and examples to support your analysis.
Capital Lease: Analyze the risks and benefits of the business choosing to purchase a capital lease, including the necessary ethical considerations, appropriate calculations, and examples to support your analysis.

Financial Evaluation: In this section of the report, you will now determine if the three available financial options in the Project Two Financial Assumptions document are appropriate for the business, considering the analysis you did in the first section. You will also explain financing and describe the business’s likely future performance.

Financing: Explain how a business finances its operations and expansion.
Bond Investment: Assess the appropriateness of a bond investment as a financing option for the business’s financial health, using your financial analysis and other financial information to your support claims.
Capital Equipment: Assess the appropriateness of a capital equipment investment as a financing option for the business’s financial health, using your financial analysis and other financial information to support your claims.
Capital Lease: Assess the appropriateness of a capital lease purchase as a financing option for the business’s financial health, using your financial analysis and other financial information to support your claims.
Short-Term Financing: Explain how potential short-term financing sources could help the business raise needed funds for improving its financial health. Base your response on the business’s current financial information.
Future Financial Considerations: Describe the business’s likely future financial performance based on its current financial well-being and risk levels. Use financial information to support your claims.

Financial Recommendations: In this section of the report, you will recommend which financing option(s) are the best for the business to choose depending on its financial health.

Financial Recommendation(s): Recommend the most appropriate financing option(s) based on the business’s financial health, including a rationale for why the option(s) are best. Balance Sheet

Powered by Clearbit

Disney (Walt) Co. (The) (NYS: DIS)

Exchange rate used is that of the Year End reported date

As Reported Quarterly Balance Sheet

Report Date 07/03/2021 04/03/2021 01/02/2021 06/27/2020 03/28/2020 12/28/2019 06/29/2019 03/30/2019 12/29/2018

3rd Quarter 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter

Currency USD USD USD USD USD USD USD USD USD

Audit Status Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited

Consolidated Yes Yes Yes Yes Yes Yes Yes Yes Yes

Scale Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands

Cash & cash equivalents 16070000 15890000 17068000 23115000 14339000 6833000 6728000 10108000 4455000

Receivables 13355000 12533000 14051000 12622000 14532000 17100000 15673000 14593000 10123000

Inventories 1344000 1406000 1480000 1559000 1531000 1571000 1516000 1445000 1357000

Licensed content costs & advances 2367000 2204000 1423000 3135000 1869000 1334000 4526000 5408000 824000

Other current assets 830000 844000 852000 899000 1003000 938000 1035000 1257000 778000

Assets held for sale – – – – – – 1892000 1466000 –

Total current assets 33966000 32877000 34874000 41330000 33274000 27776000 31370000 34277000 17537000

Produced & licensed content costs 27889000 26858000 25929000 25560000 26757000 26539000 22552000 24353000 8177000

Investments 4045000 4309000 4037000 3611000 3180000 3312000 3872000 4080000 2970000

Attractions, buildings & equipment 64023000 63037000 63017000 61130000 60929000 59910000 57457000 57991000 55385000

Accumulated depreciation – attractions, buildings & equipment 37579000 36866000 36380000 34639000 33713000 33057000 32088000 33132000 31069000

Parks, resorts & other property before projects in progress & land, Total 26444000 26171000 26637000 26491000 27216000 26853000 25369000 24859000 24316000

Projects in progress 4856000 4891000 4547000 4380000 3916000 4023000 4853000 4984000 4336000

Land 1077000 1075000 1079000 1020000 1019000 1019000 1170000 1174000 1145000

Parks, resorts & other property, net 32377000 32137000 32263000 31891000 32151000 31895000 31392000 31017000 29797000

Intangible assets, net 17601000 18123000 18642000 19589000 22037000 22669000 25114000 26985000 6747000

Goodwill 77835000 77861000 77800000 77233000 80320000 80314000 77801000 75057000 31289000

Noncurrent assets held for sale – – – – – – 12591000 13182000 –

Other assets 8508000 8085000 8343000 8435000 8575000 8443000 4783000 5391000 3424000

Total assets 202221000 200250000 201888000 207649000 206294000 200948000 209475000 214342000 99941000

Accounts payable & other accrued liabilities 18317000 17062000 16846000 16986000 17906000 19755000 17647000 20503000 10696000

Current portion of borrowings 4728000 5243000 5397000 10224000 12676000 10018000 21923000 19158000 3489000

Deferred revenue & other current liabilities 4368000 4337000 4303000 3707000 4891000 5024000 4730000 4281000 3434000

Liabilities held for sale – – – – – – 293000 434000 –

Total current liabilities 27413000 26642000 26546000 30917000 35473000 34797000 44593000 44376000 17619000

Commercial paper borrowings – – – – 8483000 6534000 – – 699000

U.S. & European medium-term notes – – – – – – – – 17947000

U.S. dollar denominated notes – – – – 44289000 39380000 – – –

Asia International Theme Parks borrowings – – – – – – – – 1160000

Asia Theme Parks borrowings – – – – 1185000 1146000 – – –

Foreign currency denominated debt & other borrowings – – – – 1489000 1015000 – – 859000

Total borrowings before current portion – – – – 55446000 48075000 – – 20665000

Less: current portion of borrowings – – – – 12676000 10018000 – – 3489000

Borrowings 51110000 50903000 52878000 54197000 42770000 38057000 36311000 37803000 17176000

Deferred income taxes 6835000 6894000 7201000 7055000 7965000 8364000 10404000 11208000 3177000

Noncurrent liabilities held for sale – – – – – – 2353000 2659000 –

Other long-term liabilities 16249000 16615000 17205000 15855000 16113000 15928000 10561000 12854000 6452000

Redeemable noncontrolling interests 9492000 9410000 9330000 9162000 9096000 9029000 8897000 1103000 1124000

Common stock 55174000 55000000 54663000 54386000 54230000 53995000 53718000 53419000 36799000

Retained earnings (accumulated deficit) 40311000 39365000 38456000 39004000 43721000 43202000 41382000 41212000 84887000

Market value adjustments for investments – – – -6000 – – -1000 -4000 –

Market value adjustments for hedges -213000 – -324000 – 122000 -7000 33000 48000 128000

Market value adjustments – -214000 – – – – – – –

Unrecognized pension & postretirement medical expense -6712000 -6881000 -7072000 -5469000 -5566000 -5639000 -3155000 -3179000 -3247000

Foreign currency translation & other accumulated comprehensive income (loss) -912000 -823000 -745000 -1142000 -1193000 -887000 -598000 -651000 -663000

Accumulated other comprehensive income (loss) -7837000 -7918000 -8141000 -6617000 -6637000 -6533000 -3721000 -3786000 -3782000

Shareholders’ equity sub-total – – – – – – – 90845000 117904000

Treasury stock, at cost 907000 907000 907000 907000 907000 907000 907000 907000 67588000

Total disney shareholders’ equity 86741000 85540000 84071000 85866000 90407000 89757000 90472000 89938000 50316000

Noncontrolling interests 4381000 4246000 4657000 4597000 4470000 5016000 5884000 14401000 4077000

Total equity 91122000 89786000 88728000 90463000 94877000 94773000 96356000 104339000 54393000

Income Statement

Powered by Clearbit

Disney (Walt) Co. (The) (NYS: DIS)

Exchange rate used is that of the Year End reported date

As Reported Quarterly Income Statement

Report Date 07/03/2021 04/03/2021 01/02/2021 06/27/2020 03/28/2020 12/28/2019 06/29/2019 03/30/2019 12/29/2018

3rd Quarter 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter

Currency USD USD USD USD USD USD USD USD USD

Audit Status Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited

Consolidated Yes Yes Yes Yes Yes Yes Yes Yes Yes

Scale Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands

Services revenues 15585000 14522000 14871000 11235000 16174000 18075000 18022000 13006000 12866000

Products revenues 1437000 1091000 1378000 544000 1835000 2783000 2223000 1916000 2437000

Total revenues 17022000 15613000 16249000 11779000 18009000 20858000 20245000 14922000 15303000

Cost of services (exclusive of depreciation & amortization) 10251000 8932000 10738000 7209000 10664000 11377000 11445000 7167000 7564000

Cost of products (exclusive of depreciation & amortization) 982000 850000 1037000 687000 1254000 1639000 1374000 1209000 1437000

Selling, general, administrative & other expenses 3168000 3113000 2917000 2455000 3388000 3703000 3362000 2327000 2152000

Depreciation & amortization 1266000 1272000 1298000 1377000 1333000 1298000 1304000 828000 732000

Total costs & expenses -15667000 -14167000 -15990000 11728000 16639000 18017000 -17485000 11531000 -11885000

Restructuring & impairment charges – – – – – – – 662000 –

Restructuring & impairment charges 35000 414000 113000 5047000 145000 150000 207000 – –

DraftKings, Inc. gain (loss) -217000 – – – – – – – –

German free-to-air (FTA) television network gain (loss) 126000 – – – – – – – –

Other income (expense), net -91000 305000 – 382000 – – -123000 – –

Other income – – – – – – – 4963000 –

Interest expense 404000 415000 404000 456000 365000 362000 472000 198000 163000

Interest & investment income -9000 131000 – 41000 63000 – 34000 30000 75000

Net periodic pension & postretirement benefit costs (other than service costs) -32000 -36000 – 3000 2000 – 27000 25000 25000

Interest income, investment income & other interest income (expense) – – 80000 – – 79000 – – –

Interest income (expense), net -445000 -320000 -324000 -412000 -300000 -283000 -411000 -143000 -63000

Equity in the income (loss) of investees 211000 213000 224000 186000 135000 224000 -1000 -312000 76000

Income from continuing operations before income taxes 995000 1230000 46000 -4840000 1060000 2632000 2018000 7237000 3431000

Income taxes from continuing operations -133000 108000 16000 -331000 525000 459000 395000 1647000 645000

Net income (loss) from continuing operations 1128000 1122000 30000 -4509000 535000 2173000 1623000 5590000 –

Income (loss) from discontinued operations, net -5000 -11000 -12000 -3000 -15000 -26000 359000 21000 –

Net income (loss) 1123000 1111000 18000 -4512000 520000 2147000 1982000 5611000 2786000

Net income (loss) from continuing operations attributable to noncontrolling interests -205000 -210000 -1000 -209000 -60000 -40000 – -159000 2000

Less: net income from continuing operations attributable to noncontrolling & redeemable noncontrolling interests – – – – – – -186000 – –

Less: net income from discontinued operations attributable to noncontrolling interests – – – – – – -36000 – –

Net income (loss) attributable to The Walt Disney Company (Disney) 918000 901000 17000 -4721000 460000 2107000 1760000 5452000 2788000

Weighted average shares outstanding – basic 1818000 1817000 1812000 1809000 1808000 1805000 1802000 1530000 1490000

Weighted average shares outstanding – diluted 1830000 1829000 1823000 1809000 1816000 1817000 1814000 1537000 1498000

Year end shares outstanding 1781000 1781000 1781000 1781000 1781000 1781000 1781000 1779000 1500000

Earnings (loss) per share – continuing operations – basic 0.51 0.5 0.02 -2.61 0.26 1.18 0.8 3.55 –

Earnings (loss) per share – discontinued operations – basic – -0.01 -0.01 – -0.01 -0.01 0.18 0.01 –

Net earnings (loss) per share – basic 0.5 0.5 0.01 -2.61 0.25 1.17 0.98 3.56 1.87

Earnings (loss) per share – continuing operations – diluted 0.5 0.5 0.02 -2.61 0.26 1.17 0.79 3.53 –

Earnings (loss) per share – discontinued operations – diluted – -0.01 -0.01 – -0.01 -0.01 0.18 0.01 –

Net earnings (loss) per share – diluted 0.5 0.49 0.01 -2.61 0.25 1.16 0.97 3.55 1.86

Dividends declared per common share – – – 0.88 0.88 0.88 0.88 – 0.88

Cash Flow

Powered by Clearbit

Disney (Walt) Co. (The) (NYS: DIS)

Exchange rate used is that of the Year End reported date

As Reported Quarterly Cash Flow

Report Date 07/03/2021 04/03/2021 01/02/2021 06/27/2020 03/28/2020 12/28/2019 06/29/2019 03/30/2019 12/29/2018

3rd Quarter 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter 3rd Quarter 2nd Quarter 1st Quarter

Currency USD USD USD USD USD USD USD USD USD

Audit Status Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited Unaudited

Consolidated Yes Yes Yes Yes Yes Yes Yes Yes Yes

Scale Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands Thousands

Net income (loss) – – – – – – – – 2786000

Net income (loss) from continuing operations 2280000 1152000 30000 -1813000 2708000 2173000 9999000 8376000 –

Depreciation & amortization 3836000 2570000 1298000 4010000 2631000 1298000 2864000 1560000 732000

Net gain/(loss) on investments – -481000 -80000 – – – – – –

Goodwill & intangible asset impairment – – – 4953000 – – – – –

Net loss (gain) on investments -325000 – – – – – – – –

Net loss (gain) on acquisitions & investments – – – -370000 – – – – –

Loss (gain) on acquisition – – – – – – -4794000 -4917000 –

Deferred income taxes -749000 -556000 -105000 -548000 297000 534000 1716000 1190000 46000

Equity in the loss (income) of investees -648000 -437000 -224000 -545000 -359000 -224000 234000 236000 -76000

Cash distributions received from equity investees 546000 372000 193000 567000 405000 219000 548000 370000 170000

Net change in produced & licensed content costs & advances -3192000 -1685000 771000 -1483000 -925000 -77000 59000 -281000 468000

Net change in operating lease right of use assets / liabilities 127000 146000 36000 16000 -96000 – – – –

Equity-based compensation 428000 270000 134000 388000 246000 115000 591000 475000 92000

Other adjustments, net 728000 490000 90000 471000 156000 65000 152000 121000 61000

Receivables -301000 -37000 -1324000 2100000 828000 -1424000 -1428000 -386000 -1078000

Inventories 236000 175000 94000 86000 70000 81000 -96000 -19000 32000

Other assets -113000 -131000 -136000 8000 -174000 -33000 450000 46000 25000

Accounts payable & other accrued liabilities – – – – – – – – -1289000

Accounts payable & other liabilities 341000 -780000 -642000 -1986000 -888000 -841000 219000 -283000 –

Income taxes -260000 400000 -60000 95000 -112000 -256000 -6248000 -474000 130000

Net cash flows from operations – continuing operations – – – 5949000 4787000 – 4266000 – –

Net cash flows from operating activities 2934000 1468000 75000 5949000 – 1630000 4266000 6014000 2099000

Investments in parks, resorts & other property -2468000 -1530000 -760000 -3293000 -2585000 -1338000 -3567000 -2390000 -1195000

Acquisitions – – – – – – -9901000 -9901000 –

Other investing activities 383000 203000 28000 -27000 -21000 -12000 -317000 -392000 -141000

Net cash flows from (used in) investing activities – continuing operations – – – -3320000 -2606000 – -13785000 – –

Net cash flows from investing activities -2085000 -1327000 -732000 -3320000 – -1350000 -13785000 -12683000 -1336000

Commercial paper borrowings/(payments), net -99000 -87000 -179000 1373000 3138000 1172000 2973000 376000 -302000

Borrowings 43000 37000 1000 18030000 6071000 51000 31348000 31145000 –

Reduction of borrowings -2319000 -1816000 -139000 -2297000 -1048000 -46000 -19039000 -17398000 –

Dividends – – – -1587000 -1587000 – -1310000 -1310000 –

Proceeds from exercise of stock options 405000 394000 209000 238000 207000 126000 278000 83000 37000

Acquisition of noncontrolling & redeemable noncontrolling interests – – – – – – -1430000 – –

Contributions from or sales of noncontrolling interests – – – – – – 544000 – –

Other financing activities -801000 -769000 -225000 -838000 -165000 -186000 -831000 -200000 -146000

Net cash flows from financing activities – continuing operations – – – 14919000 6616000 – 12533000 – –

Net cash flows from financing activities -2771000 -2241000 -333000 14919000 – 1117000 12533000 12696000 -411000

Cash flows from operating activities of discontinued operations -2000 4000 – 2000 4000 – 320000 – –

Cash flows from financing activities of discontinued operations – – – – – – -179000 – –

Cash flows from investing activities of discontinued operations 8000 4000 – 198000 198000 – – – –

Cash flows from operations – discontinued operations 6000 8000 9000 200000 202000 -19000 141000 -35000 –

Impact of exchange rates on cash, cash equivalents & restricted cash 77000 70000 139000 -49000 -76000 41000 47000 75000 -44000

Change in cash, cash equivalents & restricted cash -1839000 -2022000 -842000 17699000 8923000 1419000 3202000 6067000 308000

Cash, cash equivalents & restricted cash, beginning of period 17954000 17954000 17954000 5455000 5455000 5455000 4155000 4155000 4155000

Cash, cash equivalents & restricted cash, end of period 16115000 15932000 17112000 23154000 14378000 6874000 7357000 10222000 4463000

Looking for this or a Similar Assignment? Click below to Place your Order