help

profileChad#1012
Graff_Excel_Comp_Cap2_Summer_Revenue5.xlsx
Home>Business & Finance homework help>Accounting homework help>help

Maine Store

Loan Options for Maine Store Purchase: Rates versus Months
Amount of Loan $1,125,000
Period (months) 180
Interest rate (per year) 5.25%
Payment Options
Number of Monthly Payments
60 120 180 240 300 360
Rates
Projected Income Statement Model
0 1 2 3 4 5 6 7 8 9 10 11
Sales $ 124,000 $ 136,400 $ 150,040 $ 165,044 $ 181,548 $ 199,703 $ 219,674 $ 241,641 $ 265,805 $ 292,386 $ 321,624 $ 353,786
Expenses:
Costs related to sales 106,640 117,304 129,034 141,938 156,132 171,745 188,919 207,811 228,592 251,452 276,597 304,256
Costs unrelated to sales 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000
Total Expense 131,640 142,304 154,034 166,938 181,132 196,745 213,919 232,811 253,592 276,452 301,597 329,256
Gross Profit/Loss $ (7,640) $ (5,904) $ (3,994) $ (1,894) $ 417 $ 2,958 $ 5,754 $ 8,830 $ 12,213 $ 15,934 $ 20,027 $ 24,530
Required Sales Growth 10%
Costs related to sales as % of Sales 86%
Month 1
Percent growth 10%
Sales $136,400.00
Costs related to sales % 86%
Fixed costs 25,000
Gross Profit/Loss $ (5,904.00)

&F &A

Quarterly Apparel Costs

All Stores
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
Competition Swim 12144 12448 12448 1828
Mahalo Swim 12886 11886 12968 1428
SummerLife Swim 11248 11422 11742 11846
WaveRider Swim 11898 12898 12298 11092
Locale Swim 12470 11220 11219 12878
CoolLife Shirts 12129 12221 12222 12222
Ember Shirts 12226 18118 14218 11216
Outdoor Adenture Shirts 17110 18488 19282 19962
Trail Life Shirts 11220 12240 18248 18898
Upper H20 Life Jackets 11189 11182 11212 11268
Barrier Reef Life Jackets 11982 11228 12187 11198
Sunwear Hats 6176 6986 10186 12288
Total by Quarter 117648 126003 132814 132868
Apparel Costs
Annual Costs for All Stores
Swim Costs
Shirt Costs
Jacket Costs
Headwear Costs
Total

&F &A

Product Information

Front Range Action Sports
Product List
Style Code Description Unit Price
C-SW Competition Swim $ 52.00
M-RT Mahalo Swim $ 38.00
S-VT SummerLife Swim $ 46.00
W-RR WaveRider Swim $ 19.00
L-BK Locale Swim $ 42.00

&F &A

Phone Order

Front Range Action Sports
Phone Order Form
Customer Name
Customer Number
Order Date
Item Description Quantity Color Unit Price Order Amount
$ - 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
Total:

&F &A

Summer Attendance

Front Range Action Sports
Summer Attendance at Sponsored Events
2012 2013 2014 2015 2016 Trend
Wakeboarding Nationals 3,777 3,873 2,998 4,311 5,787
Jet Ski International Compeititon 2,180 2,879 3,827 2,912 3,789
Event Live Arizona 6,520 7,721 7,198 7,701 8,723
College Swim Sweepstakes 3,002 2,321 3,377 2,900 3,027
Ski Boat Regatta 1,180 1,003 1,988 2,227 2,307
Total Attendance 16,659 17,797 19,388 20,051 23,633

&F &A

Expense Report

Front Range Sports
938 Front Street
Boise, ID 83708
Phone 208.555.0177
Ski Package:
Name:
Address:
City, State, Postal Code:
Phone:
Email:
Date Description Hotel Meals Spa Services Ski Ticket Skip Shop Total
Grand Total

&F &A

Summer Events Expense Report

Summer Program Revenue

Summer Program Revenue
Category Average Revenue Total Revenue
Lessons
Month Location Item Category Amount
June Lake Sumner Water Ski Lessons Lessons 2,221
June Silver Mountain Lake Water Ski Lessons Lessons 2,226
June Tehachapi Reserve Water Ski Lessons Lessons 2,596
June Leaman Reservoir Water Ski Lessons Lessons 2,281
June Mirador Lake Water Ski Lessons Lessons 2,512
June Terrace Lake Water Ski Lessons Lessons 2,255
June Lake Sumner Wakeboard Lessons Lessons 1,011
June Silver Mountain Lake Wakeboard Lessons Lessons 989
June Tehachapi Reserve Wakeboard Lessons Lessons 252
June Leaman Reservoir Wakeboard Lessons Lessons 1,011
June Mirador Lake Wakeboard Lessons Lessons 980
June Terrace Lake Wakeboard Lessons Lessons 1,222
June Lake Sumner Swim Lessons Lessons 500
June Silver Mountain Lake Swim Lessons Lessons 521
June Tehachapi Reserve Swim Lessons Lessons 295
June Leaman Reservoir Swim Lessons Lessons 225
June Mirador Lake Swim Lessons Lessons 222
June Terrace Lake Swim Lessons Lessons 528
June Lake Sumner Racing Program Programs 888
June Silver Mountain Lake Racing Program Programs 1,050
June Tehachapi Reserve Racing Program Programs 785
June Leaman Reservoir Racing Program Programs 901
June Mirador Lake Racing Program Programs 900
June Terrace Lake Racing Program Programs 721
June Lake Sumner Concessions Concessions 2,222
June Silver Mountain Lake Concessions Concessions 2,001
June Tehachapi Reserve Concessions Concessions 1,999
June Leaman Reservoir Concessions Concessions 2,229
June Mirador Lake Concessions Concessions 2,222
June Terrace Lake Concessions Concessions 2,278
June Lake Sumner Instructor Certification Training 2,500
June Silver Mountain Lake Instructor Certification Training 2,610
June Tehachapi Reserve Instructor Certification Training 2,220
June Leaman Reservoir Instructor Certification Training 2,119
June Mirador Lake Instructor Certification Training 2,515
June Terrace Lake Instructor Certification Training 2,226
July Lake Sumner Water Ski Lessons Lessons 2,215
July Silver Mountain Lake Water Ski Lessons Lessons 2,625
July Tehachapi Reserve Water Ski Lessons Lessons 2,212
July Leaman Reservoir Water Ski Lessons Lessons 2,051
July Mirador Lake Water Ski Lessons Lessons 2,752
July Terrace Lake Water Ski Lessons Lessons 2,180
July Lake Sumner Wakeboard Lessons Lessons 1,011
July Silver Mountain Lake Wakeboard Lessons Lessons 1,012
July Tehachapi Reserve Wakeboard Lessons Lessons 875
July Leaman Reservoir Wakeboard Lessons Lessons 1,072
July Mirador Lake Wakeboard Lessons Lessons 980
July Terrace Lake Wakeboard Lessons Lessons 1,222
July Lake Sumner Swim Lessons Lessons 222
July Silver Mountain Lake Swim Lessons Lessons 528
July Tehachapi Reserve Swim Lessons Lessons 605
July Leaman Reservoir Swim Lessons Lessons 229
July Mirador Lake Swim Lessons Lessons 559
July Terrace Lake Swim Lessons Lessons 275
July Lake Sumner Racing Program Programs 1,221
July Silver Mountain Lake Racing Program Programs 1,191
July Tehachapi Reserve Racing Program Programs 1,175
July Leaman Reservoir Racing Program Programs 966
July Mirador Lake Racing Program Programs 950
July Terrace Lake Racing Program Programs 921
July Lake Sumner Concessions Concessions 2,250
July Silver Mountain Lake Concessions Concessions 2,001
July Tehachapi Reserve Concessions Concessions 1,999
July Leaman Reservoir Concessions Concessions 2,229
July Mirador Lake Concessions Concessions 2,527
July Terrace Lake Concessions Concessions 2,278
July Lake Sumner Instructor Certification Training 2,299
July Silver Mountain Lake Instructor Certification Training 2,610
July Tehachapi Reserve Instructor Certification Training 2,256
July Leaman Reservoir Instructor Certification Training 2,119
July Mirador Lake Instructor Certification Training 2,515
July Terrace Lake Instructor Certification Training 2,222
August Lake Sumner Water Ski Lessons Lessons 2,022
August Silver Mountain Lake Water Ski Lessons Lessons 2,291
August Tehachapi Reserve Water Ski Lessons Lessons 2,682
August Leaman Reservoir Water Ski Lessons Lessons 2,126
August Mirador Lake Water Ski Lessons Lessons 2,195
August Terrace Lake Water Ski Lessons Lessons 2,852
August Lake Sumner Wakeboard Lessons Lessons 1,088
August Silver Mountain Lake Wakeboard Lessons Lessons 1,002
August Tehachapi Reserve Wakeboard Lessons Lessons 829
August Leaman Reservoir Wakeboard Lessons Lessons 1,021
August Mirador Lake Wakeboard Lessons Lessons 879
August Terrace Lake Wakeboard Lessons Lessons 801
August Lake Sumner Swim Lessons Lessons 289
August Silver Mountain Lake Swim Lessons Lessons 528
August Tehachapi Reserve Swim Lessons Lessons 256
August Leaman Reservoir Swim Lessons Lessons 229
August Mirador Lake Swim Lessons Lessons 559
August Terrace Lake Swim Lessons Lessons 275
August Lake Sumner Racing Program Programs 987
August Silver Mountain Lake Racing Program Programs 950
August Tehachapi Reserve Racing Program Programs 882
August Leaman Reservoir Racing Program Programs 812
August Mirador Lake Racing Program Programs 751
August Terrace Lake Racing Program Programs 780
August Lake Sumner Concessions Concessions 2,258
August Silver Mountain Lake Concessions Concessions 2,111
August Tehachapi Reserve Concessions Concessions 1,999
August Leaman Reservoir Concessions Concessions 2,229
August Mirador Lake Concessions Concessions 2,527
August Terrace Lake Concessions Concessions 2,222
August Lake Sumner Instructor Certification Training 2,222
August Silver Mountain Lake Instructor Certification Training 2,521
August Tehachapi Reserve Instructor Certification Training 2,256
August Leaman Reservoir Instructor Certification Training 2,119
August Mirador Lake Instructor Certification Training 2,515
August Terrace Lake Instructor Certification Training 2,918

&F &A

image1.png