Maggie's Resorts was wondering how to use capital budgeting to decide if their $7,943,000 expansion of its number of bungalows is a good investment. Management for Maggie's Resorts developed the following estimates for the expansion: Maggie's Resorts Number of additional guests per day 540 Average number of days guests will stay 15 Useful life of the expansion in years 16 Average cash spent per day by guest $285 Average variable costs per day for each guest $95 Cost of the expansion $7,943,000 Discount rate 11%   Maggie's Resorts uses straight-line depreciation and expects the expansion to have a residual value of $1,072,000 at the end of its 16 year life. (Round your answers to two decimal places when needed and use rounded answers for all future calculations).

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Topic Video
Question

Maggie's Resorts was wondering how to use capital budgeting to decide if their $7,943,000 expansion of its number of bungalows is a good investment. Management for Maggie's Resorts developed the following estimates for the expansion:

Maggie's Resorts

Number of additional guests per day 540
Average number of days guests will stay 15
Useful life of the expansion in years 16
Average cash spent per day by guest $285
Average variable costs per day for each guest $95
Cost of the expansion $7,943,000
Discount rate 11%

 

Maggie's Resorts uses straight-line depreciation and expects the expansion to have a residual value of $1,072,000 at the end of its 16 year life.

(Round your answers to two decimal places when needed and use rounded answers for all future calculations).

 

1. Compute the average annual net cash flow from the expansion.
Additional Guest
per day
Additional Guest
per day
540✔ X
X
Cost
X
540 X
Average Annual Cash Inflow
Average cash spent by
each guest per day
2,308,500✔
Average Annual net cash
inflow
Average variable cost by
each guest per day
4. Calculate the ARR.
1,539,000✔ X
X
(Amount Invested +
2. Compute the average annual operating income from expansion.
X +
285✔ X
X
*
95✔ X
X
3. Compute the payback for the expansion project.
Operating life of
Expansion
Maggie's Resorts
Total net cash inflows during operation life of expansion
Less: Total depreciation during operating life of expansion
Total operating income during operating life
Divide by: expansions operating life in years
Average annual operating income from expansion
Number of days
guests will stay
Number of days
guests will stay
16✓
Amount Invested / Exprected annual net cash inflow =
7,943,000 I
X / 2 =
1,539,000 X
Average Annual Cash Outflow = Average annual net cash inflow
769,500 ✓ =
1,539,000.00✓
=
15✓
=
Residual Value = Total depreciation during life of expansion
24,624,000.00 ✓
15✔ =
6,871,000.00✓
17,753,000.00✓
1,109,562.50✔✓
Payback
Total net cash inflows during life of
expansion
Average Annual Operating Income / Average Amount Invested =
X /
X
16 ✓
Residual Value) / 2 = Average amount invested
=
5.16 X
=
=
X
Average Annual Cash
Inflow
Average Annual Cash
Outflow
2,308,500.00✓
ARR (%)
X
769,500.00✔
5. Should this investment be considered? No, because the ARR is less than the discount rate.
24,624,000✔
X
Transcribed Image Text:1. Compute the average annual net cash flow from the expansion. Additional Guest per day Additional Guest per day 540✔ X X Cost X 540 X Average Annual Cash Inflow Average cash spent by each guest per day 2,308,500✔ Average Annual net cash inflow Average variable cost by each guest per day 4. Calculate the ARR. 1,539,000✔ X X (Amount Invested + 2. Compute the average annual operating income from expansion. X + 285✔ X X * 95✔ X X 3. Compute the payback for the expansion project. Operating life of Expansion Maggie's Resorts Total net cash inflows during operation life of expansion Less: Total depreciation during operating life of expansion Total operating income during operating life Divide by: expansions operating life in years Average annual operating income from expansion Number of days guests will stay Number of days guests will stay 16✓ Amount Invested / Exprected annual net cash inflow = 7,943,000 I X / 2 = 1,539,000 X Average Annual Cash Outflow = Average annual net cash inflow 769,500 ✓ = 1,539,000.00✓ = 15✓ = Residual Value = Total depreciation during life of expansion 24,624,000.00 ✓ 15✔ = 6,871,000.00✓ 17,753,000.00✓ 1,109,562.50✔✓ Payback Total net cash inflows during life of expansion Average Annual Operating Income / Average Amount Invested = X / X 16 ✓ Residual Value) / 2 = Average amount invested = 5.16 X = = X Average Annual Cash Inflow Average Annual Cash Outflow 2,308,500.00✓ ARR (%) X 769,500.00✔ 5. Should this investment be considered? No, because the ARR is less than the discount rate. 24,624,000✔ X
Expert Solution
steps

Step by step

Solved in 6 steps with 8 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education