Question: O Spreadsheet_18.01 Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) ED 11 AY General Paste B I U A $ 7 %

O Spreadsheet_18.01 Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) ED 11 AY General Paste B I U A $ 7 % C6 X V fx A B C D E F G H Inputs for GE Year Dividend Div growth Term value Investor CF NH beta 1.9 2019 3.12 3.12 3 mkt_prem 0.08 2020 3.3 3.38 4 r 0.029 2021 3.64 3.64 5 k_equity 0.1810 2022 3.90 3.90 6 term_gwth 0.070 2023 4.19 0.0740 4.19 2024 1.50 0.0736 4.50 8 2025 4.83 0.0732 4.83 9 2026 5.1 0.0728 5.18 10 2027 5.55 0.0724 5.55 11 2028 5.95 0.0720 5.95 12 Value line 2029 5.38 0.0716 6.38 13 forecasts of 2030 5.83 0.0712 6.83 14 annual dividends 2031 7.32 0.0708 7.32 15 2032 7.83 0.0704 7.83 16 2033 3.38 0.0700 8.38 17 Transitional period 2034 8.97 0.0700 86.43 95.39 18 with slowing dividend 19 growth 28.91 =PV of CF 20 Beginning of constant E17 * (1+F17)/(B5 - F17) 21 growth period NPV(B5, H2:H17) 22 23 Sprd 18.1Homework #02 0 Saved Help Save 3 Exit Submit Calculate the intrinsic value of Rio Tinto in each of the following scenarios by using the threestage growth model of Sgreadsheet 18.1. Treat each scenario independently. a. The terminal growth rate will be 6.00%. (Round your answer 10 2 decimal places.) 5...... TI Melences b. Rio Tinto's actual beta is 1.00. (Round your answer to 2 decimal places.) c. The market risk premium is 9.00%. (Round your answer to 2 decimal places.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Nearly There ( the Company ) , an SEC registrant, designs, develops, manufactures, and sells various navigation products and services. Because of significant research and development expenses and...

Calculate the joint ROPC for FM#1 as an input into the regression analysis. Provide a sample of your results for the 1st, 5th and 8th jtROPCs: (enter solutions as decimals rather than percentages) jt...

Calculate the joint ROPC for FP#2 as an input into the regression analysis. Provide a sample of your results for the 1st, 5th and 8th jtROPCs: (enter solutions as decimals rather than percentages) jt...

Please help with 9 In the project you will assume the role of the staff accountant for Shipping Inc., and perform Shipping Inc.'s accounting for the transactions that occurred during January 2021. A...

11. During January Shipping Inc. made credit sales for $210,000. The cost of the goods sold was $125,000. (Make summary entries for the entire month). Other information: 1. Monthly depreciation for...

attached was the journal entries and then all info from january. i am needing the general ledger for febuary, the trial balance and adjusted trial balance, balance sheet, income statement,ect. My...

AutoSave OFF AC 321 Int I - SU20 - Comprehensive Problem- Hammon(2) View Home Insert Draw Page Layout Formulas Data Review Insert WE DX Delete Format Calibri (Body) 11AA 29 29 General G Paste BIU E...

Here are the profit for 50 companies I have so far from Fortune 1000 website. Find profit or loss of 50 companies. Calculate the population parameters for all 50 companies profit or loss Select a...

As a Professional Kitchen Manager you are responsible forMenu Planning and Inventory Management to control wastage and reduce food cost. Yield management plays a very crucial role in both Menu...

3 Excel File Edit View Insert Format Tools Data Window Help AutoSave ON EA#2F2021 Acrobat Tell me Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) V 12 ' ' III General III III...

Not sure how to upload files on here. I don't think it's possible so here are screenshots of the pictures to have a clearer visual of what I need help with. THANK YOU!! 3 Part III - READ ALL...

HSA Corporation operates in two types of businesses soft drinks and food products, and has operations in two countries U.S. and Turkey. The firm had operating income of $2.45 million on its U.S....

Please write an essay, summarizing a courts interpretation in a case involving online protection of a patent. Cite both the case and statute using standard legal notation. Please include a hyperlink...

7 a Copy and complete this table of values for 60-x. b Use your table to draw a graph of y=60-x. c Where does the line cross the y-axis? d If the line is extended, where does it cross the x-axis? r...

A company is considering a new project that requires an investment of Rs. 450 lakhs in equipment and will last for six years. The expected earnings before depreciation and taxes are: Year Earnings...