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

Ids 100 project 1 lenses chart - Science - Introduction to biotechnology worksheet - In what part of a chloroplast does glucose production occur - What is the slant height of a square pyramid - In narrative format discuss the key facts and critical issues of the life, crimes, and conviction of Aileen Wuornos. - How to respond to an osha complaint letter - Program files x86 google drive googledrivesync exe - Weft faced twill weave - Natalie rogers carl rogers - Cavity balance injection molding - Eye dissection lab answerseye dissection lab answers - Elaborate art style - Economics vcaa study design - Narrative theory and adaptation - Hp point of sale touch screen - Quality dimensions worksheet - Stockholders and Management Interests - The georgians care home - Yankee trace fish fry coupon - What are some factors that affect social mobility - Is vodka a homogeneous mixture - Waterloo library room booking - 36 lynhurst dr greenville sc 29611 - Nova rise of the superstorms video questions answer key - Campaign Project: Research and Planning - Goodfellas theme - The mac robertson high school - Should students use mobile phones - Maximum pain theory calculator - Consumer behavior case study with solution - Phonological representation of a word - Samsung swot 2018 - Ann Harris - Describe how outsourcing can be used for risk transference - Need 5+ pages with no plagiarism 2+ scholarly references in APA 7 Format.Follow all instructions. - Critical appraisal app - Expressed arguments in the media - 631.2.2 - Corporate level strategy focuses on - Cryptography and Network Security - Bus timetable adelaide to murray bridge - What is the wheaties sports federation - A long solenoid with 1000 turns per meter - Darkest dungeon brackish tide pool - From wealth to power fareed zakaria pdf - A level grade boundaries - 44.10 01 smtp protocol error - Samsung model ln t4061f recall - Titration of acids and bases lab report answers - Independent project 4-5 - Fantastic mr fox chicken - Values of plate element slenderness limits - Social decentering example - The safer food group exam answers - Green gobbler urinal clog eliminator lowes - Texting is killing language - Dichotomous Key - Hess's law lab report discussion - Medisys corp case study - Brook crompton motor wiring diagram - How does mcdonald's communicate with its stakeholders - Peta kruger art work - Policing in America - 2/23 ferguson avenue labrador - Diversity in early care and education honoring differences 5th edition - The man who shot liberty valance short story pdf - Triangular trade route map - Let there be light lamp shade company - Individual programmatic assessment week five programmatic assessment - Raspberry pi music player with buttons - Locked bag 2910 central coast business centre - Mohammed mansour al rumaih trading - Serco canterbury telephone number - Wolfson brain imaging centre university of cambridge - Types of ssrs reports in ax 2012 - 4 Week Probability and Statistics Class - Guy fawkes homework help - Mise en scene examples - World music a global journey ebook only terry e miller - Vcaa study design psychology - Diageo case study capital structure - Difference between permutation and combination with example - Moral lesson of hansel and gretel - How do spines protect ocean stickleback fish - 149 cocos drive ningi - 40 short stories a portable anthology 4th edition pdf free - Identify an artifact that embodies or refers to ethical values - Warehouse manager alternative titles - The most common allegation against therapists in malpractice suits is - Poems with figurative language 5th grade - Sydney secondary college balmain campus - Eight principles of software engineering - Philosophy of biology syllabus - Emc measure mode mercedes - Unspsc code list free - Discussion Board due Friday 10.31.2020 at 3PM EST - Anne norton the signs of shopping - Answer the following question in 600 to 700 words - Star schema for student database