Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I'm having to create 3 scenarios from the given cash flow statement. Not understanding how to do this please help. AutoSave O A = Con

image text in transcribed

I'm having to create 3 scenarios from the given cash flow statement. Not understanding how to do this please help.

AutoSave O A = Con X Final Part 1 (2... Chandler Revie OR Fin: X File (11 x (11 x Get ser + O File C/Users/Chandler Revie/Downloads/Final%20Pro... s! Apps P Math XL G Google G Google YouTube M Email Other bookmarks ET Reading list Home Insert Draw Page Layout Formulas Data Review View Developer Help Power Pivot LS IN Y 3 Dala Analysis Thu AI 2 Solver Refresh Stocks Currencies Sort & Data Forecast Outline Filler Tools Get Data 90% + 0 Gel & Transform Dala Queries & Conne... Uula lypes Analyze Final Project Instructi... 2/8 Atwood Country Club The Year Cath Flow Projection Pratit Year_5 =G13 G18 B E F H Initial Growth Factor 500 1% 208 19.000 Mentors Monthly Membership Menihy Overtreed Monthly Payroll 5 Members Monthly Membership Fee Monthly Overhead Monthly Payroll Initial Growth Factors: 300 106 SGO 11 15,000 10. 10,000 20% Year 5 REVENUE Yeart Year 2 Year Year Years M 505 722 Monthly Membership Fee 30 SI 53 52 52 Annual Member Re: $ 212,200 $ 17,99 $ 1,200 $ EXPENSES Overhead 190.000 195.000 217,300 239,380 28.556 Payroll 14 172. , 202. 248882 Total Expenses $ 300.000$ 349,000 $300,000 $98.40 312.370 Net Profittore Tess 1.700$ 20,3015 (253415 55.306 REVENUE Members Monthly Membership Fee Annual Member Revenue: $ Year 1 1 500 50 300,000 $ Year 2 350 51 333,300 $ Year 000 31 270.296 $ Year 4 06b 52 411,399 $ 32 437,064 7 B 2 10 11 12 13 14 15 16 17 TU 19 20 21 22 23 20 EXPENSES: verhead Payroll TotalLxpenses: $ 120,000 120,000 300,000 198,000 1:44,000 142,000 $ 217,000 172,800 290.000 S 294,500 263,598 207,360 248,832 446,990 $ 512,370 Net Profit Before Taxes: $ 18,700) $20.304) $ (3,541) $ 55,306) 18. Create three scenarios from this cash flow statement with the scenario names and Changing Cells values shown below: Scenario Name Changing Cells Initial Fast Growth No Growth Growth_Factor_Members 10% 20% 0% Growth_Factor_Fee 1% % 20% 0% Growth Factor Overhead 10% 10% 20% Growth Factor Payroll 20% 20% 20% 25 20 27 28 29 30 31 32 33 34 35 3G 37 Sheet Sheet1 Sheet2 Sheets Ready ER FI BOX Type here to search o ENG 11:42 AM 5/10/2021

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

Step: 3

blur-text-image

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

Crypto Spotlight Series Polkadot

Authors: Nott U.r. Keys

1st Edition

979-8854241342

More Books

Students also viewed these Finance questions