help

Graff_Excel_Comp_Cap2_Summer_Revenue.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
	$9,043.62	60	120	180	240	300	360
Rates	8.00%	$22,810.94	$13,649.35	$10,751.09	$9,409.95	$8,682.93	$8,254.85
	7.50%	$22,542.69	$13,353.95	$10,428.89	$9,062.92	$8,313.65	$7,866.16
	7.00%	$22,276.35	$13,062.20	$10,111.82	$8,722.11	$7,951.27	$7,484.65
	6.50%	$22,011.92	$12,774.15	$9,799.96	$8,387.70	$7,596.08	$7,110.77
	6.00%	$21,749.40	$12,489.81	$9,493.39	$8,059.85	$7,248.39	$6,744.94
	5.50%	$21,488.81	$12,209.21	$9,192.19	$7,738.73	$6,908.48	$6,387.63
	5.00%	$21,230.14	$11,932.37	$8,896.43	$7,424.50	$6,576.64	$6,039.24
	4.50%	$20,973.40	$11,659.32	$8,606.17	$7,117.31	$6,253.12	$5,700.21
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	$ 12,144	$ 12,448	$ 12,448	$ 1,828
Mahalo Swim	12,886	11,886	12,968	1,428
SummerLife Swim	11,248	11,422	11,742	11,846
WaveRider Swim	11,898	12,898	12,298	11,092
Locale Swim	12,470	11,220	11,219	12,878
CoolLife Shirts	12,129	12,221	12,222	12,222
Ember Shirts	12,226	18,118	14,218	11,216
Outdoor Adenture Shirts	17,110	18,488	19,282	19,962
Trail Life Shirts	11,220	12,240	18,248	18,898
Go Explore Shirts	9,500	9,695	8,315	9,275
Upper H20 Life Jackets	11,189	11,182	11,212	11,268
Barrier Reef Life Jackets	11,982	11,228	12,187	11,198
Sunwear Hats	6,176	6,986	10,186	12,288
Total by Quarter	$ 152,178	$ 160,032	$ 166,545	$ 145,399
Apparel Costs
Annual Costs for All Stores
Swim Costs	$ 220,267
Shirt Costs	$ 276,805
Jacket Costs	$ 91,446
Headwear Costs	$ 35,636
Total	$ 928,510

&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

help

Maine Store

Quarterly Apparel Costs

Product Information

Phone Order

Summer Attendance

Expense Report

Summer Program Revenue

image1.png