1. Using the Base case below, complete an analysis which considers PPP FX Forecast ...

70.2K

Verified Solution

Question

Finance

1. Using the Base case below, complete an analysis which considers PPP FX Forecast

imageimage

BASE CASE NO Inflation, and NO change in Exchange Rates Projected Revenues: Cost Per Project Year New Contracts On going Contracts 0 4 20 30 20 10 10 20 50 70 $ 21,000.00 Set up Fees $420,000.00 $630,000.00 $ 420,000.00 $210,000.00 $210,000.00 $180,000.00$ 450,000.00 $ 630,000.00 $540,000.00 $360,000.00 $600,000.00 $1,080,000.00 $1,050,000.00 $750,000.00 $570,000.00 $9,000.00 Annual License Fees Total Revenue Cash Costs: $ 14,000.00 240000 if less than 55 or 360000 for more than 55 Set Up $280,000.00$420,000.00 $ 280,000.00 $140,000.00 $140,000.00 $240,000.00 $240,000.00 $ 360,000.00 360,000.00 $240,000.00 Other Operating Depreciation/Amortization EBIT $280,000.00 $ 280,000.00$280,000.00 $240,000.00 $ 380,000.00 $360,000.00 $500,000.00 $380,000.00 $156,000.00 247,000.00$234,000.00 $325,000.00 $247,000.00 $ 84,000.00 133,000.00$126,000.00 $175,000.00 $133,000.00 35.00% Taxes Net Operating Income After Taxes Add Depreciation Net Operating Cash Flows Recovery of Capital Assets (AT) $280,000.00 $ 280,000.00$280,000.00 $364,000.00 413,000.00$406,000.00 $175,000.00 $133,000.00 $ 65,000.00 840000 Project Cost (840,000.00) $ (840,000.00) $364,000.00 S413,000.00 0.86 406,000.00 $175,000.00 $198,000.00 Total Cash Flow (CAD) Exchange Rate Total Cash Flow (USD) 0.86 0.86 0.86 0.86 0.86 $ (722,400.00) $313,040.00 $ 355,180.00 $ 349,160.00 $150,500.00 $170,280.00 $1,057,294.46 28.87% 9.65% NPV IRR Accept Analysis as such or Reject Accept Variables and Data Year-End Exchange Rate Forecast, Canadian Dollar in U.S. Dollars (USD/CAD) 2014 (Spot Rate)0.860 2015 2016 2017 2018 2019 0.825 0.805 0.790 0.780 0.775 Data: Discount Rate for Valuation US Inflation Canada Inflation 9.65% 1.50% 1.75% BASE CASE NO Inflation, and NO change in Exchange Rates Projected Revenues: Cost Per Project Year New Contracts On going Contracts 0 4 20 30 20 10 10 20 50 70 $ 21,000.00 Set up Fees $420,000.00 $630,000.00 $ 420,000.00 $210,000.00 $210,000.00 $180,000.00$ 450,000.00 $ 630,000.00 $540,000.00 $360,000.00 $600,000.00 $1,080,000.00 $1,050,000.00 $750,000.00 $570,000.00 $9,000.00 Annual License Fees Total Revenue Cash Costs: $ 14,000.00 240000 if less than 55 or 360000 for more than 55 Set Up $280,000.00$420,000.00 $ 280,000.00 $140,000.00 $140,000.00 $240,000.00 $240,000.00 $ 360,000.00 360,000.00 $240,000.00 Other Operating Depreciation/Amortization EBIT $280,000.00 $ 280,000.00$280,000.00 $240,000.00 $ 380,000.00 $360,000.00 $500,000.00 $380,000.00 $156,000.00 247,000.00$234,000.00 $325,000.00 $247,000.00 $ 84,000.00 133,000.00$126,000.00 $175,000.00 $133,000.00 35.00% Taxes Net Operating Income After Taxes Add Depreciation Net Operating Cash Flows Recovery of Capital Assets (AT) $280,000.00 $ 280,000.00$280,000.00 $364,000.00 413,000.00$406,000.00 $175,000.00 $133,000.00 $ 65,000.00 840000 Project Cost (840,000.00) $ (840,000.00) $364,000.00 S413,000.00 0.86 406,000.00 $175,000.00 $198,000.00 Total Cash Flow (CAD) Exchange Rate Total Cash Flow (USD) 0.86 0.86 0.86 0.86 0.86 $ (722,400.00) $313,040.00 $ 355,180.00 $ 349,160.00 $150,500.00 $170,280.00 $1,057,294.46 28.87% 9.65% NPV IRR Accept Analysis as such or Reject Accept Variables and Data Year-End Exchange Rate Forecast, Canadian Dollar in U.S. Dollars (USD/CAD) 2014 (Spot Rate)0.860 2015 2016 2017 2018 2019 0.825 0.805 0.790 0.780 0.775 Data: Discount Rate for Valuation US Inflation Canada Inflation 9.65% 1.50% 1.75%

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students