Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please help me find the correct numbers to input in cells C11 through C16? I am looking at AAPL's Form 10-K on the

image text in transcribed

Can someone please help me find the correct numbers to input in cells C11 through C16? I am looking at AAPL's Form 10-K on the given websites but I do not know the breakdown of their debt. (Also C13 might not be the correct value)

image text in transcribed
fin330_spreadsheet_template Q~ Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut Arial 8 A- A Wrap Text Custom 2 AutoSum Copy Fill AP Paste Format Merge & Center $ ~ % 2 60 $.0 Conditional Format Cell Insert Delete Format Sort & Formatting as Table Styles Clear Filter C11 X Vfx 0 A B C D E F G H This tab is used to calculate Weighted Average Cost of Capital (WACC). Enter data in the yellow cells only. Comments to help you are indicated IN (0 00 - ) CAPITAL STRUCTURE For End of Fiscal Year 2019 Unaudited; Amounts USD x 1000 SIMPLE C. Jeffrey Smith: TEXTBOOK METHO All of the funds the organization has received c from banks, bond-buyers, stockholders, and other investors. (Does not include Accounts % Cost of $ Cost of Capital per Re Payable and accrued expenses.) Funds pital, After Tax Year (Column C x 10 Capital Funding Amount invested found on Form 10-K (Annual Report) Savings Coumn G) Wgt x Cost % 11 Debt: Bank Loans $ filed with the Securities and Exchange Commission (SEC) 0.0% $ 0.0000% 12 Debt: Bonds 0.0% 0.0000% 13 Debt: Commercial Paper 5,980.0 https://www.sec.gov/edgar/searchedgar/comp 0.0% 0.0000% 14 Debt: Other or Unidentified anysearch.html 0.0% 0.0000% 15 Leases (a form of Debt) 0.0% 16 Preferred Stock (if any) Form 10-K also available on Mergent Online 0.0000% under Reports tab. 0.0% 0.0000% 17 Common Stock: At Par 45, 174,000.0 0.0% 0.0000% 18 Common Stock: Add'l Paid-in Capital 19 Retained Earnings 45,898,000.0 Important to review cost of capital reading in 0.0% 0.0000% text. 0.0% 0.0000% 20 [Other 0.0% 0.0000% 21 TOTAL $ 91,077,980.0 0.0000% 22 23 WEIGHTED AVERAGE COST OF CAPITAL: 24 WACC = [$ Total Annual Cost of Capital] / [$ Total Capital Funding] $0 / $91077980 0.0000% 25 26 Amount Pct of Total a and Financial History Capital Structure Valuation + Cell C10 commented by C. Jeffrey Smith 187%%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Company Valuation Playbook Invest With Confidence

Authors: Charles Sunnucks

1st Edition

1838470816, 978-1838470814

Students also viewed these Finance questions

Question

According to the Balanced Scorecard, what is a strategy?

Answered: 1 week ago