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

Ethical Dilemma Project: Case Selection - Information systems for managers 2nd edition - Discussion - 560 paper - Www galencollege edu student portal - Activity 13.4 glacier national park investigation answers - 978-0-13-410398-3 - FINAL PAPER (Health Law) - Australian beer can collectors association - Jimmy walker basketball born 1944 - Assignment front page format in word download - Motorola strategy analysis - Elsewhere in america the crisis of belonging in contemporary culture - Shower drain heat exchanger - The real cost of cheap fashion worksheet answers - Pandora 6 game list - Holes chapter questions and answers pdf - The financial industry uses business intelligence to predict hardware failures - Bank vision statement examples - Create an advertising campaign assignment - Figurative language television show - Ucsd 2016 2017 calendar - Strengths and limitations of visually interpreting histograms - Management information system book by james o brien - Open geospatial consortium inc - Consists of several layers of cells allowing an expandable lining - Respiratory soap note example - Desegregation and Public Schools - How to measure benefits - CBR - A firm has a total debt ratio of .47. this means the firm has 47 cents in debt for every: - Memento psychology assignment - Stock order book viewer - Travelling salesman problem using hill climbing in java - Mid quarter vs half year - Dq response - What is recommendation in report writing - Assassin's creed odyssey can you save phila - Converting hard copy documents to electronic files - Ethics in policing administration - Information system security - The retained earnings statement shows - Evidence-Based Project, Part 5: Recommending an Evidence-Based Practice Change - Cognitive walkthrough pros and cons - Help with Case Anaylsis Powerpoint Slide - Halls of residence monash clayton - A-5 - Famous cases involving plea bargaining - The norton introduction to literature 13th edition table of contents - Horse attacking human dream - Anle corporation has a current stock price of - Mitta mitta river rafting map - Fmdq daily quotation list - Discussion-APA Format - Gen 499 week 3 discussion 1 - 21 pilots car radio lyrics - Discussion board - How do i make a brochure in word - Sample siop lesson plan - Howe truss bridge pros and cons - Tesla balanced scorecard - Search white pages online - Canvas sydney edu au - Active directory proposal - Compound words definition for kids - Knewton alta answers - Assignment 2 - I NEED SOMEONE TO EDIT MY COVER LEVER BASED ON THE FEEDBACK - Peter johnson police scanner tasmania - The shadow club characters - Who can complete this assignment by 11:59pm tomorrow August 4th? - Six simple machines physics - Different theoretical views on national debt - Discussion week1 - Analyzing Emergency & Disaster Concepts - Cambridge pembroke study abroad - Clinical performance measures for nurse practitioners - Extron cable cubby 500 cut out template - Failed to establish a backside connection in datapower - A man flies a small airplane from fargo to - Civil law /criminal law - Nc state engineering career fair - A practical companion to ethics pdf free - El puerto de liverpool mexico - ECE 332 WK 3 DQ 1 - The curious researcher by bruce ballenger 7th edition - Euler path and circuit examples - Nursing C-W-P (due 24 hours) - Aggressive marketing in the context of format wars - Db technologies fifty line - Leadership essay - Report Non Metallic Process - The first step in the screening process for potential markets and sites is to ________. - Servant leadership and followership similarities - The plaint of the camel poem questions and answers - Corporate finance ross ppt - Amylase lock and key - Discussion Question NSG 4074 - The afterlife of cellphones - Discuss case 9.2 hsbc combats fraud in split second decisions