Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Forecast Worksheet for crescent rident Thit is Vear $ - the Averate Numerica Chaqce Amual columi of your Operating budget: Fertatat Workaher: fer Sommir Valliry

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Forecast Worksheet for crescent rident Thit is Vear $ - the Averate Numerica Chaqce Amual columi of your Operating budget: Fertatat Workaher: fer Sommir Valliry Exhibit CR-2: Crescent Ridae Golf Colirca Dounde Lietant Exhibit CR-3: Crescent Ridge Golf Course Financial History \begin{tabular}{|c|c|c|c|c|c|} \hline ColrOperailos Reveass & Year 1 & Var2 & Ytar3 & Yoar 4 & Years \\ \hline Green kes & 5786240 & seg175 & si.037.612 & \$1.101525 & 51089.884 \\ \hline roumamout poes. & si.21.5. & sizono: & sobods & 551.805 & 54094 \\ \hline GotfCar Kentals & 520262 & & 324505 & 5163,425 & 536475 \\ \hline Rivige: & 528506 & sangez. & 51894 & 519.207 & szoz70 \\ \hline Golf tquijment Rontal & 515xin: & 516.930 & & $14570 & 514289 \\ \hline Intruclion & 516052 & siz290 & ssige & 13228 & 54,231 \\ \hline Playce Devidopment: & 50.252 & sones & sisas & & 51,437 \\ \hline & & 510950 & 504500 & 570250 & 569410 \\ \hline Cost orciools sola () & & & & & (sspine \\ \hline coosin: & 65% & 709 & arias & 8184 & sin \\ \hline Merchitudive Gross Mtarin & smastb & 52110 & ssgoos & stason & 5990 \\ \hline Tetal Colroperation Revenue. & 51359.992 & S1.410.929 & 51505.761 & sis70.620 & 51.537 .440 \\ \hline Cou Orratioss Exriows & yean 1 & & & Yrine & res5 \\ \hline Labor (Wayes, Benefits, Taxes) & sin20 & & & 5016159 & soss.5 \\ \hline Instriction Fees Pud to Fingloyse & 51060 & & 5129 & & $2.,750 \\ \hline Playes Dev. Fes Pad to Eingloses & & sisa: & 5+53 & 31.37 & 5921 \\ \hline Utilities & & ssiog & 552,509 & & 53.603 \\ \hline Makting and hochstion & SSA20 & sosis & senso & 55923 & 156100 \\ \hline Fadure & 52,652 & & & 52003 & \\ \hline Eidacaticu and Truvel & 58.163 & ss.7.7. & 58,928 & 39248 & 59525 \\ \hline GolfCar Lase & 574.880 & 59.680 & 574.550 & & 574.580 \\ \hline GolfCa Mainteused & 520,000 & sapisio & & 5901506 & s3039 \\ \hline Golf Car Electicidy & 515,500 & 515065 & & sics3 & salias \\ \hline Range Sippplies & 55.409 & & & soss & 56006 \\ \hline Tetal Colroperation Expense & $429,182 & 44561 & cos54 & 5+4957 & 5460,565 \\ \hline Xerincoutr & Yous 1 & & xries & Wris 4 & mon5 \\ \hline Golfoperution Net tocume & 5970.810 & simsas & 51000.220 & & 51.075478 \\ \hline Food ind Baverare Ner linoues. & 514200 & 13xsog & (6.1) & & anisos \\ \hline Net Ins, Defore Vactigri Expens. & 5945.910 & 52668 & $1,04720 & 51,100,241 & sxass,ass \\ \hline & & yean2 & resin 3 & Voxit & Yrans \\ \hline & & & & & cossogso \\ \hline Other fiaciling Lxpense & astion & issagos. & (gomiles & (Bestry & Bentisy \\ \hline Abunistnatice Expenci & & & courin. & ations & \\ \hline Totat Fasmis Expenes. & & & & arovan & stiscon \\ \hline Net tocoue Below Deth Somes & 596710 & & suosing & sunsos & sens.3a? \\ \hline Dobe service (sz milina lane) & & Hesing & & & csenssist \\ \hline Net lacame anter Debt Servise: & 512.54 & sions. & saray: & soosus & sasul \\ \hline \end{tabular} Click ent linsoge to enbiyes Exhibit SV-2: Summit Valley Country Club Membership Trends and Rounds History \begin{tabular}{|l|c|c|c|c|c|} \hline Non-Equity Social & $113,400 & $142,200 & $167,400 & $273,600 & $297,600 \\ \hline \begin{tabular}{l} Total Annual \\ Revenue \end{tabular} & $2,143,680 & $2,059,080 & $2,043,960 & 52,087,280 & $2,027,520 \\ \hline \end{tabular} Ciikion limage to entarje. \begin{tabular}{|l|c|c|c|c|c|} \hline \multicolumn{1}{|c|}{ Round TyPE } & YEAR 1 & YEAR 2 & YEAR 3 & YEAR 4 & YEAR 5 \\ \hline Weekday & 14,250 & 13,325 & 12,344 & 13,007 & 12,898 \\ \hline Weekend/Holiday & 10,040 & 11,030 & 12,037 & 10,998 & 10,840 \\ \hline Total Rounds & 24,290 & 24,355 & 24,381 & 24,005 & 23,738 \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|c|} \hline \multicolumn{1}{|c|}{ RoLND TYPE } & YEAR 1 & YEAR 2 & YEAR 3 & YEAR 4 & YEAR 5 \\ \hline \begin{tabular}{l} Member \\ Tournament Rounds \end{tabular} & 3,550 & 3,130 & 2,798 & 2,478 & 1,987 \\ \hline \begin{tabular}{l} Member Non- \\ Toumament Rounds \end{tabular} & 16,107 & 16,522 & 16,879 & 16,829 & 17,064 \\ \hline \begin{tabular}{l} Outside Tournament \\ Rounds \end{tabular} & 4,100 & 4,178 & 4,205 & 4,211 & 4,225 \\ \hline Guest Rounds & 533 & 525 & 499 & 487 & 462 \\ \hline Total Rounds & 24,290 & 24,355 & 24,381 & 24,005 & 23,738 \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|c|} \hline \multicolumn{1}{|c|}{ RouND TYPE } & YEAR 1 & YEAR 2 & YEAR 3 & YEAR 4 & YEAR 5 \\ \hline Men & 19,917 & 18,997 & 18,529 & 18,004 & 17,091 \\ \hline Women & 3,644 & 4,140 & 4,389 & 4,321 & 4,748 \\ \hline Juniors & 729 & 1,218 & 1,463 & 1,680 & 1,899 \\ \hline Total Rounds & 24,290 & 24,355 & 24,381 & 24,005 & 23,738 \\ \hline \end{tabular} \begin{tabular}{|l|c|c|c|c|c|} \hline \multicolumn{1}{|c|}{ RotND TYPE } & YEAR 1 & YEAR 2 & YEAR 3 & YEAR4 & YEAR 5 \\ \hline Men & 82% & 78% & 76% & 75% & 72% \\ \hline Women & 15% & 17% & 18% & 18% & 20% \\ \hline Juniors & 3% & 5% & 6% & 7% & 8% \\ \hline Total Rounds & 100% & 100% & 100% & 100% & 100% \\ \hline \end{tabular} Exhlbit SV-3: Summit Vallou Countni Cluh Elnamalal uined

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

Measuring Business Interruption Losses And Other Commercial Damages An Economic Approach

Authors: Patrick A. Gaughan

3rd Edition

1119647916, 9781119647911

More Books

Students also viewed these Accounting questions

Question

Graph. x Answered: 1 week ago

Answered: 1 week ago