STEM EXAM 1 File
xlsx
keyboard_arrow_up
School
Texas Tech University *
*We aren’t endorsed by this school
Course
5320
Subject
Finance
Date
Apr 3, 2024
Type
xlsx
Pages
21
Uploaded by koolbabu007
Question 16 thru 20
Simplified Statements for MSFT
Income Statement
FY2018
Sales
110,360
COGS
38,353
SGA
36,949
Depreciation
14,410
EBIT
20648
Interest Expense
2,733
EBT
17,915
Taxes
3,583
Net Income
14,332
Dividends
5,916
OCF
38,641 =EBIT + Depr + Taxes
NCS
22,361 =endNFA - begNFA + Dep
CFA
7,696 =OCF - NCS - dNWC
Balance Sheet
FY2017
FY2018
Cash
132981
133768
Acct. Receivable
19792
26481
Inventory
2181
2662
Other Current Assets
4897
6751
Net Fixed Assets
81235
89186
Total Assets
241086
258848
7,390
8617
Long Term Debt
161302
167513
Common Stock
69315
71223
Retained Earnings
3079
11495
Total Liab. And Equity
241,086
258848
Current Assets
159851
169662
Current Liabilities
7,390
8617
NWC
152,461
161045
8,584 dNWC
Acct. Payable
Questions 21 thru 23
Cash
133,768,000,000
Sales
110,360,000,000
EBIT
20,648,000,000
Net Income
14,332,000,000
Depreciation
14,410,000,000
Interest Bearing Debt
167,513,000,000
Total Assets
258,848,000,000
Total Shareholder Equity
82,718,000,000
Price Per Share
137
Shares Outstanding
7,790,000,000
Dividends per Share
2
Market Cap
1069411200000.00
P/E
74.61702483952 =(PPS) / (NI/Shares)
Payout Ratio
0.934886966229417 =Div/NI
0.934887
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Questions 24 thru 27
onstant: The tax rate & payout rati
Sales g
5%
Simplified Statements for MSFT
Income Statement
FY2018
PF2019
Sales
110,360
115,878
COGS
38,353
40,271
SGA
36,949
38,796
Depreciation
14,410
15,131
EBIT
20,648
21,680
Interest Expense
2,733
2,870
EBT
17,915
18,811
Taxes
3,583
717
Net Income
14,332
18,094
Dividends
5,916
7,469
Retained Earnings
8,416
10,625
Quick Ratio
19.3803 =(CA - Inv) / (CL)
IGR
0.0336059 =(ROA*retention) / (1
EFN
2317.20 EFN Deficit
COGS, SGA, Depreciation, Interest Expense, Cash, Account Receivable, Inventory, Other Current Assets, and Balance Sheet
FY2018
PF2019
Cash
133768
140,456
Acct. Receivable
26481
27,805
Tax Rate
0.20000
Inventory
2662
2,795
Payout Rat
0.412783
Other Current Assets
6751
7,089
Retention R0.587217
Net Fixed Assets
89186
93,645
ROA
0.055368
Total Assets
258848
271790.40
8617
8617
Long Term Debt
167513
167513
Common Stock
71223
71223
Retained Earnings
11495
22,120
Total Liab. And Equity
258848
269473.2
Current Assets
169662
Current Liabilities
8617
Acct. Payable
Net Fixed Asset increase spontaneously with sales
0.587217
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Questions 28 thru 30
Sales
59.43 Billions
Net Income
12.32 Billions
Free Cash Flows
3.35 Billions
Total Equity
96.36 Billions
Price per share
129.15 Billions
Shares Outstanding
1.7997 Billions
Benchmarks
P/E
20.53
P/FCF
13.35
P/S
2.15
P/B
3.12
Compar. Valuation P/E
140.540 =Benchmark P/E * (NI/Shares)
Compar. Valuation P/S
70.998 =Benchmark P/S * (Sales/Shares)
Compar. Valuation P/B
167.052 =Benchmark P/B * (TE/Shares)
Question 31
Div0
$1.35 Time
Div
g1
27% 1-5
0
$1.350 g2
3% 6-forever
1
$1.715 2
$2.177 Div_7
$4.732 3
$2.765 4
$3.512 5
$4.460 6
$4.594 7
$4.732 8
$4.874 Question 32
Forward Div $1.76 <<Div pmt per share
Shares Owne
3500
Total $ Div
$6,160.00 Question 34
Div1
$1.76 PV = CF / (r - g)
Price
$129.50 g
6.50%
r?
0.0786 = (CF / PV) + g
The Abbott Company just paid a dividend of $1.35 per share. Dividends are expected to grow at 27% for th
Disney will pay a dividend of $1.76 per share next year. The price of the stock is $129.50. D
he next 5 years, and then 3% forever. Calculate the projected dividend payment 7 years from today. (Round Dividends are expected to grow at 6.5%, forever. Calculate the implied rate of return on this investment. (Ent
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
to 3 decimals)
ter percentages as decimals and round to 4 decimals)
Question 35
1
2
3
4
Sales
160
182.4
204.29
224.72
Costs
75
85.5
95.76
105.34
Taxes
17.85
20.34
22.8
25.07
Net Income (OCF)
67.15
76.56
85.73
94.31
Net Investment
45
51.3
57.46
63.21
FCF
22.15
25.26
28.27
31.1
22.15
25.26
28.27
31.1
Shares Out
275
r
12%
g
4%
MV_Equity
$351.29 Price
$1.28 Question 36
Years to maturity: 5
5
6%
1000
92.50%
Calculate the current yield on the bond.
CY
0.032432432432433 =(CPN/2*Par) / (Price% * Par)
Calculate the yield-to-maturity (YTM) on the bond
YTM
0.0392
Question 38
Years to maturity: 20
20
5%
1000
Price: 103.75% of par value
103.75%
Calculate the yield-to-maturity (YTM) on the bond.
YTM
0.0235
Question 39
Nominal 13.50%
EXACT FI(1+ nom) = (1+re
Coupon Rate: 6%, semi-annual payments
Par Value: $1,000
Price: 92.5% of par value
Coupon Rate: 5%, semi-annual payments
Par Value: $1,000
You own an investment that had a total (nominal) return of 13.5% las
Infl
4.20%
(1+nom)/(1+infl)
Real?
0.0893
Question 40
1000
8
4.50%
3%
Price
$1,105.98 Question 41
Price
$450,000 Down
$90,000 Loan
$360,000 Years
30
APR
3.00% comp monthly
Period Rate
0.0025
PMT?
$1,517.77 Total $ Paid
$546,398.83 Total Int Paid
$186,398.83 NPER
210.700175440723 <if PMT $2200
Question 45
Years until retirement: 30
30
Years unt
45
Amount to withdraw each year in rtmt 75000
Amount to
110000
Years to withdraw in retirement: 25
25
Years to 20
Interest rate while saving: 7%
7%
Interest 9%
Interest rate in retirement: 4%
4%
Interest r
5%
Saved today (nest egg): $50,000
50,000
Saved tod
15000
Bequest: $250,000
250,000
46
The first deposit will be made one year from today, and the last depo
Calculate the amount she will need to deposit each year in order to re
PMT
#VALUE!
Par: $1,000
Time to maturity: 8 years
Coupon Rate: 4.5%, semi annual payments
Yield to maturity: 3%
Calculate the price of the bond.
You are looking at buying a home with an asking price of $450,000.
The first deposit will be made one year from today, and the last deposit will be made on the day she retires. Her
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Time
Question 48
Amt
50,000
APR
2%
0.002
Years
10
FV
$60,949.72 Total Interest $10,949.72100 Total Simple Interest
$12,189.94 =Rate * Years * PV
Mike just put $50,000 into an account that promises to pay 2% APR 49. Mike just put $50,000 into an account that promises to pay 2% APR (annual compounding). Calculate the to
5
6
242.7
257.26
113.77
120.6
27.08
28.7
101.85
107.96
68.27
72.37
33.58
35.59
37.0136
Terminal V
462.67
33.58
498.26
eal)(1+infl)
st year. Assume the inflation rate was 4.2%, calculate the real rate of return on the investment using the Ex
)-1 = real
FV
osit will be made on the day she retires. Her first withdrawal will occur on the day she retires.
each her retirement goal.
Since the market is hot, you plan to put in an offer for the full asking price. You also plan to put a $90,000
first withdrawal will occur on the day she retires. Calculate the amount she will need to have saved on the
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
(annual compounding). Calculate the total interest earned over a 10 year holding period. (Round to 2 decim
otal simple interest earned over a 10 year holding period. (Round to 2 decimals)
xact Fisher Equation. (Enter percentages as decimals and round to 4 decimals)
0 down payment and finance the remainder. Your bank is offering you a 30-year loan at 3% APR (compounded
day she retires. (Enter a positive value and round to 2 decimals)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
mals)
d monthly). Assume your first payment is made one month from today, calculate your monthly loan payment.
(Enter a positive value and round to 2 decimals)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Net Sales
COGS
Depreciation
EBIT
Interest
Taxable Income
Taxes
Net Income
2019 Income Statement
Dividends
Additions to Retained Earnings
147
647.74
3,456
1,895
235
1,326
320
1,006
211.26
794.74
arrow_forward
ect Assignment
The preliminary 2024 income statement of Alexian Systems, Incorporated, is presented below:
ALEXIAN SYSTEMS, INCORPORATED
Income Statement.
For the Year Ended December 31, 2024
($ in millions, except earnings per share)
Revenues and gains:
Sales revenue
Interest revenue
Other income
Total revenues and gains.
Expenses:
Cost of goods sold
Selling and administrative expense
Income tax expense
Total expenses
Net Income
Earnings per share
$ 435
6
128
569
247
158
41
446
$123
$ 12.30
Saved
Help
Additional information:
1. Selling and administrative expense includes $28 million in restructuring costs.
2. Included in other income is $120 million in income from a discontinued operation. This consists of $90 million in operating
income and a $30 million gain on disposal. The remaining $8 million is from the gain on sale of investments.
3. Cost of Goods Sold in 2024 includes an increase of $10 million to correct an understatement of Cost of Goods Sold in 2023. The
amount is material.…
arrow_forward
A10
arrow_forward
21p1
arrow_forward
C1
arrow_forward
E 18-1
Comprehensive
The following is from the 2018 annual report of Kaufman Chemicals, Inc.:
Statements of Comprehensive Income
Years Ended December 31
income
• LO18-2
2018
2017
2016
Net income
$856
$766
$594
Other comprehensive income:
Change in net unrealized gains on investments,
net of tax of $22, ($14), and $15 in 2018, 2017,
and 2016, respectively
34
(21)
23
Other
(2)
$888
(1)
$744
$618
Total comprehensive income
Kaufman reports accumulated other comprehensive income in its balance sheet as a component of shareholders
equity as follows:
($ in millions)
2018
2017
Shareholders' equity:
Common stock
355
355
Additional paid-in capital
Retained earnings
Accumulated other comprehensive income
8,567
6,544
8,567
5,988
107
75
Total shareholders'equity
$15,573
$14,985
Required:
1. What is comprehensive income and how does it differ from net income?
2. How is comprehensive income reported in a balance sheet?
3. Why is Kaufman's 2018 balance sheet amount different from the 2018 amount…
arrow_forward
6
arrow_forward
Perform a horizontal analysis of the company
arrow_forward
Company C had the following investment. Help them determine the financial statement implications of the investment.
Tax rate
Estimated tax payment
21%
21,000
Investment cost and ending fair values for 20X1 and 20X2:
20X1
20X2
Cost
Fair value
Total gain
100,000
110,000
10,000
100,000
134,000
34,000
20X1 income statement information:
Sales
Expenses
1,670,200
1,536,600
Assuming the investement is short-term, what is the deferred taxes payable on the 20X1 balance sheet?
arrow_forward
Compute NET Profit margin ratio
arrow_forward
ACC610
arrow_forward
Problem 19-4 Per-Share Ratios (LO3, CFA6)
You are given the following information for Smashville, Incorporated.
Cost of goods sold:
Investment income:
Net sales:
Operating expense:
Interest expense:
Dividends:
Tax rate:
Current liabilities:
Cash:
Long-term debt:
$ 200,000
$ 2,700
$ 333,000
$ 47,000
$ 7,400
$ 16,000
21%
$ 26,000
$ 21,000
$ 21,000
Other assets:
$ 43,000
$ 159,000
Other liabilities:
$ 5,000
Fixed assets:
Investments:
Operating assets:
$ 47,000
$ 39,000
During the year, Smashville, Incorporated, had 20,000 shares of stock outstanding and depreciation expense of $15,000. Calculate the
book value per share, earnings per share, and cash flow per share.
Note: Do not round intermediate calculations. Round your answers to 2 decimal places.
Book value per share
Earnings per share
Cash flow per share
$
12.85
arrow_forward
Exercise 13-3 (Algo) Computing and analyzing trend percents LO P1
Sales
Cost of goods sold
Accounts receivable.
2021
$ 706,675
363,004
34,274
2020
2019
$464,918 $ 371,9341
238,808 193, 136
27,058
25,477
2018
$ 260,094
133,898
15,268
2017
$ 194, 100
98,991
13,296
Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether
the situation as revealed by the trend percents appears to be favorable or unfavorable.
arrow_forward
Problem 17-5 (AICPA Adapted)
Investment in Hall Company at equity
statement of financial position:
Accounts receivable, net of allowance
Fearsome Company showed the following comparative
2021
2020
Cash and cash equivalents
2,350,000
600,000
1,000,000
2,200,000
2,000,000
5,000,000
1,050,000) ( 800,000)
400,000
350,000
700,000
850,000
2,000,000
1,500,000
4,000,000
Inventory
Land
Property, plant and equipment.
Accumulated depreciation
Goodwill
400,000
12,500,000
9,000,000
Accounts payable
Note payable - long term
Bonds payable
Share capital, P100 par
Share premium
Retained earnings
Treasury shares, at cost
600,000
500,000
1,600,000
5,250,000
2,700,000
1,850,000
550,000
2,100,000
4,000,000
1,750,000
1,300,000
700,000)
12,500,000
9,000,000
Additional information for 2021
1. The net income for the current year was P3,050,000.
2. Cash dividend paid amounted to P2,500,000.
3. The entity sold equipment costing P200,000, with carrying
amount of P50,000, for P70,000 cash.
4. The entity issued…
arrow_forward
man.1
arrow_forward
O Cambridge Busines P
Module 11 I Financial Statement Forecasting
LO2 M11-12. Forecast an Income Statement
SATE
OLOGY
STX)
SEAGATE TECHNOLOGY PLC
Consolidated Statement of Income
For Year Ended June 28, 2019, $ millions
BC
$10,390
Revenue.
7,458
Cost of revenue
991
Product development
Marketing and administrative
Amortization of intangibles.
Restructuring and other, net.
453
23
(22)
Total operating expenses.
8,903
Income from operations.
1,487
Interest income
84
Interest expense
Other, net
(224)
25
Other expense, net.
(115)
Income before incorne taxes
(Benefit) provision for income taxes
1,372
(640)
Net income..
$ 2,012
Forecast Seagate's 2020 income statement assuming the following income statement relations (ST
Revenue growth.
Cost of revenue
Product development
Marketing and administrative
Amortization of intangibles.
Restructuring and other, net,
Interest income...
Interest expense.
Other, net
Income tax rate.
5%
71.8% of revenue
9.5% of revenue
4.4% of revenue
No change
$0
No…
arrow_forward
Correct answer please Q11
arrow_forward
Exercise 12-JA Cvaiuate risk ratios (LU12-3)
The 2021 income statement of Adrian Express reports sales of $18,957,000, cost of goods sold of $11,971,500, and net income of
$1,690,000. Balance sheet information is provided in the following table.
ADRIAN EXPRESS
Balance Sheets
December 31. 2021 and 2020
2021
2020
Assets
Current assets:
Cash
Accounts receivable
Inventory
$ 690, 000
1, 580, 000
$ 850, 000
1, 090, 000
1, 490, 000
1, 980, 000
4, 330, 000
$7, 760, 000
Long-term assets
4, 890, 000
Total assets
$9, 140, 000
Liabilities and Stockholders' Equity
Current liabilities
$1,930, 000
2, 390, 000
1,910, 000
2, 910, 000
$1, 750, 000
Long-term liabilities
2, 490, 000
1,910, 000
Common stock
Retained earnings
1, 610, 000
Total liabilities and stockholders' equity
$9, 140, 000
$7, 760, 000
Industry averages for the following four risk ratios are as follows:
Average collection period
Average days in inventory
Current ratio
25 days
60 days
2 to 1
Debt to equity ratio
50%
Required:
1. Calculate…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial & Managerial Accounting
Accounting
ISBN:9781285866307
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning

Accounting (Text Only)
Accounting
ISBN:9781285743615
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Related Questions
- Net Sales COGS Depreciation EBIT Interest Taxable Income Taxes Net Income 2019 Income Statement Dividends Additions to Retained Earnings 147 647.74 3,456 1,895 235 1,326 320 1,006 211.26 794.74arrow_forwardect Assignment The preliminary 2024 income statement of Alexian Systems, Incorporated, is presented below: ALEXIAN SYSTEMS, INCORPORATED Income Statement. For the Year Ended December 31, 2024 ($ in millions, except earnings per share) Revenues and gains: Sales revenue Interest revenue Other income Total revenues and gains. Expenses: Cost of goods sold Selling and administrative expense Income tax expense Total expenses Net Income Earnings per share $ 435 6 128 569 247 158 41 446 $123 $ 12.30 Saved Help Additional information: 1. Selling and administrative expense includes $28 million in restructuring costs. 2. Included in other income is $120 million in income from a discontinued operation. This consists of $90 million in operating income and a $30 million gain on disposal. The remaining $8 million is from the gain on sale of investments. 3. Cost of Goods Sold in 2024 includes an increase of $10 million to correct an understatement of Cost of Goods Sold in 2023. The amount is material.…arrow_forwardA10arrow_forward
- 21p1arrow_forwardC1arrow_forwardE 18-1 Comprehensive The following is from the 2018 annual report of Kaufman Chemicals, Inc.: Statements of Comprehensive Income Years Ended December 31 income • LO18-2 2018 2017 2016 Net income $856 $766 $594 Other comprehensive income: Change in net unrealized gains on investments, net of tax of $22, ($14), and $15 in 2018, 2017, and 2016, respectively 34 (21) 23 Other (2) $888 (1) $744 $618 Total comprehensive income Kaufman reports accumulated other comprehensive income in its balance sheet as a component of shareholders equity as follows: ($ in millions) 2018 2017 Shareholders' equity: Common stock 355 355 Additional paid-in capital Retained earnings Accumulated other comprehensive income 8,567 6,544 8,567 5,988 107 75 Total shareholders'equity $15,573 $14,985 Required: 1. What is comprehensive income and how does it differ from net income? 2. How is comprehensive income reported in a balance sheet? 3. Why is Kaufman's 2018 balance sheet amount different from the 2018 amount…arrow_forward
- 6arrow_forwardPerform a horizontal analysis of the companyarrow_forwardCompany C had the following investment. Help them determine the financial statement implications of the investment. Tax rate Estimated tax payment 21% 21,000 Investment cost and ending fair values for 20X1 and 20X2: 20X1 20X2 Cost Fair value Total gain 100,000 110,000 10,000 100,000 134,000 34,000 20X1 income statement information: Sales Expenses 1,670,200 1,536,600 Assuming the investement is short-term, what is the deferred taxes payable on the 20X1 balance sheet?arrow_forward
- Compute NET Profit margin ratioarrow_forwardACC610arrow_forwardProblem 19-4 Per-Share Ratios (LO3, CFA6) You are given the following information for Smashville, Incorporated. Cost of goods sold: Investment income: Net sales: Operating expense: Interest expense: Dividends: Tax rate: Current liabilities: Cash: Long-term debt: $ 200,000 $ 2,700 $ 333,000 $ 47,000 $ 7,400 $ 16,000 21% $ 26,000 $ 21,000 $ 21,000 Other assets: $ 43,000 $ 159,000 Other liabilities: $ 5,000 Fixed assets: Investments: Operating assets: $ 47,000 $ 39,000 During the year, Smashville, Incorporated, had 20,000 shares of stock outstanding and depreciation expense of $15,000. Calculate the book value per share, earnings per share, and cash flow per share. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Book value per share Earnings per share Cash flow per share $ 12.85arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningAccounting (Text Only)AccountingISBN:9781285743615Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning

Financial & Managerial Accounting
Accounting
ISBN:9781285866307
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning

Accounting (Text Only)
Accounting
ISBN:9781285743615
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning