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

Marriott chain of command - Aura underfloor heating controls instructions - HOMEWORK: MEDIA AND INTERNET – ACCURATE VERSUS INACCURATE - Which statement is most likely correct about retirement planning - The life-cycle of a typical moss includes - Nutrition discussion - How to calculate dilution factor in spectrophotometer - How to say australia in hiragana - Dcm personal care sdn bhddcm personal care sdn bhd - Can a pmo accelerate the implementation process discussion - Blank usa nickname of a record label headquarter - Organisational culture model by harrison 1993 - MHA500 Discussion, paper and powerpoint - Information governance - Then morris gleitzman teaching resources - Critic of the Arts- APA FORMAT - Insertion paddle wheel flow meter - Ifrs 8 operating segments ppt - Order 2207873: HIPPA - Penalty for 20km over speed limit - Substance abuse - Oxalic acid sodium hydroxide - Informatica version control best practices - Beck row primary school - X 3 7x 2 x 7 - People of Indian Heritage // People of Turkish Heritage // People of Vietnamese Heritage - Certificate ii in kitchen operations online - Discuss - Discussion board - Business law and Ethic - Policy Analysis Part I: - Eagle pcb design tutorial - Draw a network diagram for the project - St modans high school website - Reflection Paper - 12 bar blues composition project - Buntot mo hila mo meaning - Balanced equation for combustion of cyclohexane - Netflix Company Analysis - How to figure out molecular geometry - Cascaded amplifier gain formula - Master Jackets - Forming ionic compounds worksheet - Http abacus bates edu ganderso biology resources writing htwsections html - Financial Performance Evaluation questions - Video Essay - Qct full registration portfolio examples - Module 07 Quiz - Papa john's medium pizza size inches - Amp gauge wiring diagram - Graduate certificate tesol deakin - An estimate of the demand function for household furniture - Who was W e b Dubois? - Maslow's Hierarchy of Needs Paper - Lufthansa heavy baggage fee - Project Management Expert Online - Deadline and Price Non Negotiable - - Mean median mode range assessment - Outward recoil of chest wall - Asgard term deposit rates - Manchester united soccer club case study project management - 5-0-5 agility test results - The short story and its writer 9th edition - Awc ashford edu writing tools thesis generator html - Conditioned play audiometry protocol - Tutorial 3 case problem 1 html - Inorganic contaminants present in a sample of water lab report - Basics of information technology ppt - Which is better controlled access or contention explain - The house on mango street those who don t - Bio Research Paper - for Essays Guru only - Best practice performance management systems - Customers with special requirements definition - Are havighurst and santrock saying the same thing - You're only a rebel from the waist downwards - Wireless communication - Ohio university puzzle - Things that rhyme with pussy - Multi level retaining wall - Baker colin foundations of bilingual education and bilingualism - Mcfarland funeral home tryon nc obits - Discussion questions about joseph and his brothers - Facial recognition software its reliability effectiveness and admissibility - 5 guidelines for developmentally appropriate practice - Empowering leadership and effective collaboration in geographically dispersed teams, - MA_D2 - The astonishing color of after sparknotes - 1 pages(due)15 hrs - Thornton industries began construction of a warehouse - Plastimo 4 man valise liferaft - Database system and file system - Mass media ethics case studies - The family crucible characters - Letter for getting permission - Week 7 BUS320: E-Commerce and E-Business - Mortar spraying machine price in india - Community teaching work plan proposal - 95 management interview questions and answers pdf - Directed writing igcse examples - Individual analyzing published research article - Write a 5-7 page (double-spaced 12pt font) essay on the following: