STEM EXAM 1 File

xlsx

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

Report
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