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

Mode $06 reference chart - Must be detailed and no copy and paste,and no plagiarism - Tachometer working principle ppt - Homosexuality in the great gatsby - Lumo energy pay my bill - Operating cycle of a merchandising company vs service company - Essas Guru - Teachers mutual bank account number s1 - How would you describe sunset boards cash flows for 2014 - Insights Into Criminal Behavior - Write a essay - What are the characteristics of the rococo style of art - Business ethics - Land residual method formula - Use pareto analysis to investigate the following data - Wilmot proviso definition apush - Bridge to terabithia activities - Grignard reaction synthesis of triphenylmethanol lab report - First buddhist council at rajagaha - VAT Assessment - Acct 220 final exam - How does ino help odysseus - Juvenile Delinquency - Dawson states that he is chairman of the board quizlet - Instantaneous center of zero velocity problems - Amazon supply chain management strategy - Objective of service catalogue management process - Eataly reimagining the grocery store case analysis - Case study IT crisis about company - 2 pages with slides - 6.4 Nonprofit Fundraising Case Study: Part II - What does rein zinn mean - Response to intervention case study - Pgcc human resources - Risks associated with servant leadership - Business Intelligence - Another day in paradise song meaning - Alde heating system parts - Tensar geogrid installation guide - Fundamentals of nursing 9th edition potter and perry apa citation - Virtual lab half life answer key - Assignment 2 - Analyzing foreign market entry strategies extending the internalization approach - Role performance model of health - Case Study on Moral Status - How to read literature like a professor chapter 3 summary - Adobe dtm cheat sheet - Red ted reading scheme - Presented below is a list of accounts in alphabetical order - America riveting prospects by ed crooks financial times - Cow eye dissection steps - Alicia has been asked to approve a marketing campaign that - Nike sustainability report 2017 pdf - Sample assessment and treatment plan - Point of sale data flow diagram - Statistics Writing Assignment - Human Service Stakeholders Essay - Behavior modification project research paper - Critical thinking consider the verdict 6th edition test bank - Minimum number of teeth to avoid interference - Tina jones neurological assessment answers - Articlee writing - What makes a good salt bridge - Marvell noir - Capital structure decision - Ethical issues raised by the milgram study - Lab 2 water quality and contamination - Examples of informative language function - A family friend has asked your help in analyzing - Tableau disaster recovery - Realism vs liberalism vs constructivism chart - A&p flix activity dna replication - Week 5 2340b - Sfas table - Offense cycle - Dr allen pain management - Labview clad exam preparation - Lang may yer lum reek pronunciation - Yeo valley primary school - Vw swot analysis - Stark wrecking vintage classic salvage yard - Bangladesh consulate general sydney - Sona systems temple - Explain the difference between lan and wan firewall rules - Split plot design in r - Someday i died korean book english - Zero blunt topo pcr - Noughts had alls spent - 2 pages due by 24 hours - A level grade boundaries - Nursing Project - Picot question examples for falls - Job sites for teens - Five sector circular flow model - Galeria indigena puerto vallarta - Dr. biasiotto basketball study - Tok presentation marking criteria - Philosophical discussion of moral issues typically involves - It general controls review - Three beads are placed along a thin rod - Alliteration romeo and juliet