Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Tamiu course descriptions

08/04/2021 Client: muhammad11 Deadline: 2 Day

Answer the Module 3 Problem Set questions using the Excel spreadsheet provided.

Remember that when you use the perpetuity formula, the formula automatically presents values for the perpetuity one period, so if you use the perpetuity formula in year 7, the result is as of the beginning of year 7 and not the end.

MCM Inc. Sales growth Costs (% of sales): Cost of Goods Sold Advert., Prom., & Selling General & Administrative Rates: Tax rate Discount rate Results PV of NCF (incl. TV) + Cash - Debt Total Equity (M$) - # of shares outstanding (M) - Price/share ($) Yrs. 1-6 6% 55% 20% 6% 20% 8% 3.0 6.0 22.0 7+ 3.0% Cash F Sales Cost of Goods Sold Advert., Prom., & Selling General & Administrative Net Income before Tax Taxes Net Income after Tax Cash flow adjustments: Working Capital Capital Expenditures Net Cash Flows 1 102.0 2 (4.0) (3.3) (4.0) (3.2) Cash Flows 3 (3.5) (3.3) 4 5 6 (3.0) (3.4) (3.0) (4.0) (1.5) (2.0) TV JTM Airlines Rates: Discount rate Risk-free rate 1 2 3 4 5 Scenario: No Real Options 6 7 8 5 Scenario: Real Options 6 7 8 Cash from Operations minus: Capital Expenditures = Net Cash Flow Terminal Value PV of NCF 1 Cash from Operations minus: Capital Expenditures = Net Cash Flow Terminal Value PV of NCF PV of Cap. Ex. (Yrs. 1-2) 2 3 4 o: No Real Options 9 10 11 12 13 14 15 rio: Real Options 9 10 11 12 13 14 15 Option Pricing: PV of Cap. Ex. (Yrs. 1-2) Maturity PV of NCF Risk free rate Volatility BS calculations: d1 N(d1) d2 N(d2) Price of call Difference: - Value of Option over PV - % of PV on over PV #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! JTM Airlines Airport Expansion Start Phase I Phase II Phase III Success 60% PV of Revenues 250 25 East Coast 20% 75 Failure 40% 15 Success 75% 30 185 West Coast 20% 55 Failure 25% Success 60% 35 Success 80% 20 400 20 Caribbean 30% 80 Start Failure 20% 25 Failure 30% Failure 40% 5 - 20 - 20 Costs Net Probability Expected Value MGMT 332 Corporate Finance I Module 3: Risk Analysis, Real Options, and Capital Budgeting Problem Set 3 – Risk Analysis, Real Options, and Capital Budgeting 1. Company Valuation Your manager has asked you to value MCM Inc., a potential acquisition. To make your life easier, your manager gave you some of the numbers in the Excel template file provided. Your manager wants the dollar price per share, so you must calculate the dollar value of the equity and then divide by the number of shares outstanding. 2. Real Options a. JTM Airlines, where you work, is looking at potentially buying more gates at their home airport. If it pays the airport $1M, JTM will hold exclusive rights to buy those gates for $9M (at the start) and $9M (one year later) at any time in the next 3 years. The option expires at the end of year 3. JTM's discount rate is 6.5% and the risk free rate is 3%. What is the NPV of the gate purchases if it bought them today? Use the data in the Excel template provided. b. After you run the numbers for part A, you remember back to your ERAU corporate finance class's coverage of real options. You know that the 3-year option has value, so you decide to calculate it by: 1. Present valuing the purchase price of the gates separately using the riskfree rate. Once JTM decides to go ahead with the purchase, there is no risk to that expenditure. 2. Present valuing the Net Cash Flow excluding those purchase prices. This calculation will include Cap. Ex.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Homework Tutor
Assignments Hut
Math Specialist
Smart Tutor
Professional Accountant
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$17 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

I have read your project details. I can do this within your deadline.

$48 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I have read your project details. I can do this within your deadline.

$38 Chat With Writer
Math Specialist

ONLINE

Math Specialist

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$35 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

I have read your project details. I can do this within your deadline.

$34 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

I have read and understood all your initial requirements, and I am very professional in this task.

$45 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Convert stopwatch time to seconds in excel - El escorial birthday cake tomb - Waratah barbed wire price - Joaquín y fernanda escriben mensajes electrónicos. - Perfect square trinomial x 2 4x - Ts eliot essays hsc - Statins stat case study answers - 40 n 116 e - Week 5 assignment essay ideal citizen in a totalitarian government - Discussion 2 - Performance Appraisal Process Evaluation - Great alexandrov and petrooshki tea company - Unit 9 discussion - Firms that do the product leadership strategy well include which of the following factors: - Close reading of a poem - What device is used to create a physical star topology - In the upward sloping segment of the aggregate supply curve - Nasw standards of practice - Assume that adults have iq scores that are normally distributed - Fit to wander shay mitchell - Speeding fine nsw under 10km - NEED 3+ PAGES WITH 3 REFERENCES CITED IN APA FORMAT - Glasgow caledonian university bookshop - Pwdump download windows 10 - Discussion (400 words) - A thermocouple is a temperature measurement device that consists - What is maize offal - 5 i's of romanticism - Disney's design case study answers - HW 1 - Humn 8660 - Venerable dreadnought twin autocannon - Tcp xmas tree dropped sonicwall - A paper on Mercedes Benz Vision AVTR Concept, Advanced technologies & impact on Automobile industry - Security infrastructure design document example - Autocad 2d drawing exercise - What three elements are present in glucose fructose and galactose - 1960s era vocab worksheet - No gumption by russell baker questions and answers - Creative arts - Kfc lowers the price of a bucket of fried chicken - Cloud Computing - Family Medicine 20 - What does manor mean in the middle ages - Classifying living things virtual lab - Walgreens inventory turnover - Project report - Airtran 297 anatomy of an urban legend - Dr morrison walden ny - Wk 10 - Chameleon mil whip antenna - Jet blue airlines company history - Philosophy Discussion - Fair pricing in business ethics - Malware Responses - Study of natural phenomena - Respond - Teesside university software download - Which of the following statements about lysosomes is incorrect - A cheerleading staple that was patented in 1971 by herkimer - What is accounting equation explain with example - What is the difference between corporal punishment and capital punishment - What is q in mcat - Python Assignment - Data analysis for quality improvement - Managerial Finance - High country inc produces and sells many recreational products - Naturally weight loss - Awful dreams lightnin hopkins lyrics - Ward 6 victoria hospital kirkcaldy - Labview multiple plots on xy graph - Tim burton art style - Discussion: Response - Amazon vs walmart case study answers - Number the stars genre - Food dye spectrophotometry lab report - To kill a mockingbird chapter themes - Jolly phonics d action - Karma kismet new delhi delhi - Oxidation state of mn in mno42 - Objectives of science club - Bill cooper after the flood - Durham english literature reading list - Bad reviews is the opportunity - Discussion (mk) - Coefficient of friction graph - A repeater is a connecting device that operates in the - Chccs english home weebly - Hog bristle half colour schemes - Discrete Mathematics( Graph theory) - Anatomy and physiology 2 lab practical - What is a fraction equivalent to 4 4 - What is integrity interview question - Dfas travel voucher form - Participation requirements appointment centrelink - Funny props for skits - Acc 250 week 1 assignment - See if i care readworks - Break break break poem - Chapter four great gatsby - Types of audible notification appliances