i need to find the NPV, IRR , Profitability Index and Change in NPV Scenario AnalysisAnnual MilesPercent CityPrice of FuelBest Case20,00080% $3.00Base Case15,00060% $2.50Worst Case10,00040% $2.00CFOC01 to C07Best CaseBase CaseWorst CaseSSS$700 $990$700 $521$700 $226Discount Rate35.0%NPVIRRPaybackProfitability IndexBest Case$45.321550.0%1.11.18Base Case1.1Worst Case1.1Sensitivity AnalysisChange in NPVAnnual Miles -1000Percent City -5%Fuel Price-$1

Scenarios:Best Case: High annual miles (20,000), high city driving percentage (80%), and low fuel…

Answered: Scenario Analysis Annual Miles Percent…

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter2: Financial Statements, Cash Flow, And Taxes

Section: Chapter Questions

Problem 14SP

See similar textbooks

Similar questions

. Using a MARR of 15%, the preferred Alternative is:TABLE P6-82 Data for Problems 6-82 through 6-85 A B C D ECapital investment $60,000 $90,000 $40,000 $30,000 $70,000Annual expenses 30,000 40,000 25,000 15,000 35,000Annual revenues 50,000 52,000 38,000 28,000 45,000Market value at EOY 10 10,000 15,000 10,000 10,000 15,000IRR ??? 7.4% 30.8% 42.5% 9.2%(a) Do nothing (b) Alt. A (c) Alt. B(d) Alt. C (e) Alt. D (f) Alt. E
MANAGEMENT OF TECHNOLOGY Project Selection Based on Economic Analysis 0.1 = MARR' Technology "A" Year Cost Income Net NPV IRR 0 -$650,000 $0 -$650,000 $148,621 17% 1 $0 $125,000 $125,000 2 $0 $175,000 $175,000 3 -$275,000 $300,000 $25,000 4 $0 $400,000 $400,000 5 $200,000 $200,000 $400,000 Technology "B" Year Cost Income Net NPV IRR 0 -$750,000 $0 1 $0 $175,000 2 $0 $200,000 3 -$370,000 $225,000 4 $0 $375,000 5 $300,000 $350,000 Technology "C" Year Cost Income Net NPV IRR 0 -$808,300 $0 1 $0 $200,000 2 $0 $225,000 3 -$265,000 $250,000 4 $0 $400,000 5 $202,000 $325,000 Increment B-A Year Cost Income Net NPV IRR 0 -$100,000 $0 -$100,000 -$23,453 5% 1 $0 $50,000 $50,000 2 $0 $25,000 $25,000 3 -$95,000 -$75,000 -$170,000 4 $0 -$25,000 -$25,000 5 $100,000 $150,000 $250,000 Increment C-A Year Cost Income Net NPV IRR 0 -$158,300 $0 1…
How do i create an NPV graph on excel using these data: Unit Sale NPV 1,000,000.00 - 2,952,452.00 1,500,000.00 - 2,001,492.00 2,000,000.00 - 1,050,533.00 2,500,000.00 - 384,861.00 2,789,077.17 - 3,000,000.00 280,811.00 3,500,000.00 946,482.00 4,000,000.00 1,612,154.00 4,500,000.00 2,277,826.00
‏ABFHRL437 Corporation’s info is bel ow: Sales $509,000 VC $101,800 FC $22,730 NOI $384,470 Q. How much is ABFHRL437’s Contribution Margin? A. $
Match the following measurements with the terms below: Question 15 options: 12345 cash conversion efficiency ratio 12345 economic ordering quantity 12345 credit terms 12345 net working capital 12345 days of working capital 1. 5.1% 2. 47.2 days 3. 1/10, n/30 4. $200,000 5. 700 units
Year Advertising Expenditure ($000) Membership Subscriptions 2013 51 62 2014 58 68 2015 62 66 2016 65 66 2017 68 67 2018 76 72 2019 77 73 2020 78 72 2021 78 78 2022 84 73 2023 85 76 Forecast 2024 membership using moving average method, clearly explaining the limitations of this method. (show all workings)
Consider the following projects: Project C0 C1 C2 A −$ 2,100 +$ 2,000 +$ 1,200 B −2,100 +1,440 +1,728 Calculate the profitability index for A and B assuming a 22% opportunity cost of capital. Note: Do not round intermediate calculations. Round your answers to 4 decimal places.
Present Value Index Tasty Doughnuts has computed the net present value for capital expenditure at two locations. Relevant data related to the computation are as follows: Des Moines Cedar Rapids Total present value of net cash flow $712,500 $848,000 Amount to be invested (750,000) (800,000) Net present value $(37,500) $ 48,000 a. Determine the present value index for each proposal. Round your answers for the present value index to two decimal places. Des Moines Cedar Rapids Total present value of net cash flow $fill in the blank 1 $fill in the blank 2 Amount to be invested fill in the blank 3 fill in the blank 4 Present value index fill in the blank 5 fill in the blank 6 b. Which location does your analysis support?Des Moines , because the net present value index is greater than 1.
Spreadsheet Link What is the IRR of the following project?Cash FlowYear0 -32,0001. 9,0002. 10,0003. 15,0004. 7,800 1). 10.8% 2). 11.2% 3). 11.7%4). 12.0% 5). 12.3%
Whatiseachofthefollowinginvestmentsworthtodayassuminganannualdiscountrateof 7%? 1.(a) A3-yearmaturity“B”ratedcorporatebondwith4%annualinterestpaymentsanda principal value of £1,000
Use the below information to answer the following questions: 20202021Sales$11,573$12,936Depreciation 1661 1736Cost of goods sold 3979 4707Other Expenses 846 924Interest Expense 776 926Cash 6067 6466Accounts Receivables 8034 9427Short-term Notes Payable 1171 1147Long-term debt 20,320 24,696Net fixed assets 50,888 54,273Accounts Payable 4384 4644Tax rate 26% 34%Inventory 14,283 15,288Payout ratio 33% 30% A. Create the Balance Sheets for 2020 & 2021.
Use the below information to answer the following questions: 20202021Sales$11,573$12,936Depreciation 1661 1736Cost of goods sold 3979 4707Other Expenses 846 924Interest Expense 776 926Cash 6067 6466Accounts Receivables 8034 9427Short-term Notes Payable 1171 1147Long-term debt 20,320 24,696Net fixed assets 50,888 54,273Accounts Payable 4384 4644Tax rate 26% 34%Inventory 14,283 15,288Payout ratio 33% 30% A. Create the Income Statements for 2020 and 2021 (including dividends paid and retained earnings).

SEE MORE QUESTIONS

Recommended textbooks for you

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

SEE MORE TEXTBOOKS