Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the Income statement for 5 years below, what is the total payback period (highlighted cell)? Show all work. Income Statement Year 0 Year
Based on the Income statement for 5 years below, what is the total payback period (highlighted cell)? Show all work.
Income Statement Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Total Machines/Equipment Cost $ Other Construction/Renovation Cost $ (3,100,000) (800,000) Gross Patient Revenue $ 9,671,000 $ 10,258,997 $ 10,135,889 $ 10,014,258 $ 9,894,087 $49,974,231 Net Patient Revenue $ 3,497,180 $ 3,674,137 $ 3,201,852 $ 3,133,012 $ 3,065,652 $16,571,833 $ $ Expenses: Salaries & Wages Employee Benefits Supplies Utilities Rent Other Department Expenses Depreciation Expense Direct Overhead Expenses Allocation - Corporate Office Overhead Expenses Total Expenses before Corporate Overhead Operating Income $ $ $ $ $ $ $ $ $ $ $ 911,040 273,312 $ 96,000 $ 240,000 $ 120,000 48,000 $ 780,000 $ 403,500 $ 418,370 $ 3,290,222 $ 206,958 $ 947,482 284,244 99,840 249,600 124,800 49,920 780,000 11,57 433,491 3,380,947 $ $ $ $ $ $ $ $ 985,381 $ 295,614 103,834 $ 259,584 129,792 $ 51,917 780,000 $ 390,992 443,423 3,440,536 $ (238,684) $ $ 1,024,796 $ 307,439 107,987 $ 269,967 134,984 $ 53,993 $ 780,000 $ 371,442 454,122 3,504,730$ (371,718) $ 1,065,788 $ 4,934,487 319,736 $ 1,480,346 112,306 519,967 280,766 $ 1,299,917 140,383 649,959 56,153 $ 259,983 780,000$ 3,900,000 352,870 $ 1,930,373 465,601 $ 2,215,006 3,573,603 $17,190,039 (507,951) $ (618,206) $ $ $ $ 293,190 $ $ $ 206,958 780,000 $ $ 293,190 780,000 (238,684) $ 780,000 $ (507,951) 780,000 $ Net operating income Depreciation Net salvage value Net cash flow $ (371,718) $ 780,000 $ $ 408,282 $ (3,900,000) $ 986,958 $ 1,073,190 $ 541,316 $ 272,049 (3,900,000) $ (2,913,042) $ (1,839,852) $ (1,298,536) $ (890,255) $ (618,206) Cumulative Cash Flows $ Payback period Payback method has two main deficiencies when used as a project selection criterion. First, payback ignores all cash flows that occur after the payback period. Second, payback ignores the opportunity costs associated with the capital employedStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started