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

Prevention and Mitigation Analysis (Powerpoint) - Lead and manage team effectiveness - Saturated water properties calculator - Velocity squared equation - Convergence and the Reshaping of Mass Communication - Essay - Kristen bell for the first time in forever - Isolation of limonene from orange peels - Susan snow and bruce nickell - East calder health centre - All 5 states of matter - Resspond to classmates discussin - Birtinya island master plan - Soleasi nel mio cor - Affine cipher decryption example - As nzs 4777.1 2016 free - Spying on miss muller - Royal newcastle aero club - Article summary - Mother in hebrew transliteration - Paper on blockchain use - Ethno-etiology - Binghamton meal plan c - Khufu when was he born - Document b web dubois modified answer key - Conventions of a narrative - Islamic environmental ethics law and society - Discussion: Designing Mixed Methods Research - People process technology principle ppt - A comparative balance sheet for shabbona corporation - African illness a case of parasites answer key - IT ticketing system project - Orsett hospital blood test - Advantage of gram stain over simple stain - Vending machine program in python - I follow him to serve my turn upon him technique - In media res definition - Teaming at disney animation - My many colored days art activities - Einstein's big idea worksheet - Voomtech - Determining the chemical formula for copper gluconate - They say i say templates chapter 1 answers - How to do percentage analysis in spss - Where was john logie baird born - Trade licence renewal kmc - Nikolai gogol the overcoat analysis - Which troop leading step involves the leader verbally communicating - The stanford prison experiment hypothesis - Wjec physics equation sheet - Soap note for strep throat - DNP Nursing & Psychology - Ethical violations in milgram's study - Ask save myloc to help me - 4 phases of adlerian therapy - Vcat vic gov au renting notice - Conch republic electronics case study - Unix shell scripting cheat sheet - Trimdek foam infill strips - Limitations to a study examples - Medical appointment reminder text message sample - What is a quantitative observation - Project Management- Reflection & Discussion- Week 15 - Medford mail tribune election results - Osmosis potato experiment salt solution - Managing a successful business project - A four reaction copper cycle post lab answers - Pearson texas algebra 2 1 2 practice attributes of functions - Bradford tribble avocat - Bsbadm405 assessment - SSG110 Module 3 Case Study: Value - Strategic decisions ostensibly commit the firm for - My nissan maxima won t start - Size acceptance behavior assessment - Oh no inc sells three models - Am i addicted to sexting quiz - Calculate mean arterial pressure - Medicaid discounting can cause hardships - Air force defence guard - What does hamartia mean - Vertical curved list in powerpoint - Event SWOT Analysis - Scrabble dictionary text file - Air hole bunsen burner - Sum of the parts valuation damodaran - Terminal and instrumental values examples - Jk flip flop lab experiment - Ato weekly tax table - Individual success plan - Strategic management mcdonalds - Is stock price maximization good or bad for society - Hambledon hunt north pony club - Project team leadership presentation cpmgt 300 - 2 address instruction example - Me and my family tree by joan sweeney pdf - Keystone learning services sunflower ozawkie ks - The four types of adjusting entries - Why do unicellular organisms divide - Enterprise information management gartner - Los baker van a peru sparknotes