Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose that Blooper's customers paid their bills with an average 3-month delay (instead of 2 months) and that Blooper's inventories were 20% rather than 15%

image text in transcribed

image text in transcribed

Suppose that Blooper's customers paid their bills with an average 3-month delay (instead of 2 months) and that Blooper's inventories were 20% rather than 15% of next year's expenses. Use the below Blooper spreadsheet. See SPREADSHEET 9.1 in the eBook for the baseline project evaluation and resulting NPV assuming 15% inventory expense SPREADSHEET 9.1 Financial projections for Blooper's Magnoosium mine (dollar values in thousands) 19.500 3. 900 22.080 Inputs Initial Investment Salvage value Initial revenue Initial expenses Inflation rate Discount rate Acct receiv. as % of sales Inven. as of expenses Tax rate 13, 800 Spreadsheet Name Investment Salvage Initial rev Intial_exp Inflation Disc_rate AR Inv_pet Tax_rate 0.05 0.12 1/4 0.2 0.21 a. Would project NPV be higher or lower than that in the Blooper spreadsheet? O Lower Higher b. Calculate Blooper's working capital in each year of its project. (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Year Working Capital 5.948 9,009 0 1 2. 3 4 5 6 c. What is the change in project NPV? (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) The NPV from $4,223 to Suppose that Blooper's customers paid their bills with an average 3-month delay (instead of 2 months) and that Blooper's inventories were 20% rather than 15% of next year's expenses. Use the below Blooper spreadsheet. See SPREADSHEET 9.1 in the eBook for the baseline project evaluation and resulting NPV assuming 15% inventory expense SPREADSHEET 9.1 Financial projections for Blooper's Magnoosium mine (dollar values in thousands) 19.500 3. 900 22.080 Inputs Initial Investment Salvage value Initial revenue Initial expenses Inflation rate Discount rate Acct receiv. as % of sales Inven. as of expenses Tax rate 13, 800 Spreadsheet Name Investment Salvage Initial rev Intial_exp Inflation Disc_rate AR Inv_pet Tax_rate 0.05 0.12 1/4 0.2 0.21 a. Would project NPV be higher or lower than that in the Blooper spreadsheet? O Lower Higher b. Calculate Blooper's working capital in each year of its project. (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Year Working Capital 5.948 9,009 0 1 2. 3 4 5 6 c. What is the change in project NPV? (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) The NPV from $4,223 to

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurial Finance

Authors: Gary E. Gibbons, Robert D. Hisrich, Carlos Marques DaSilva

1st Edition

1452274177, 978-1452274171

More Books

Students also viewed these Finance questions