Indiana University Southeast Capstone 1 Winter Revenue Excel Worksheet

User Generated

tevmmylzna2209

Business Finance

Description

Just follow the directions in the word doc. I will upload everything you need to complete the project.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions. Hi! Please see file for your checking, I already finished the task :) If you're good with it, you can close the ticket, and leave a good remark or a tip will surely be appreciated. If you have more questions, clarifications, and requests, you may do so! It is my pleasure to help you :)Please note that I'll mark it as complete because I already made all instructions in the paper, but if you have still clarifications/requests, you may do so :) Please feel free to ask :)

Loan Options for Idaho Store Purchase: Rates versus Months
Amount of Loan
Period (months)
Interest rate (per year)

$950.000
120
5,75%

Payment Options
Number of Monthly Payments

Rates

$10.428,08
8,50%
8,00%
7,50%
7,00%
6,50%
6,00%
5,50%
5,00%

60
$19.490,70
$19.262,57
$19.036,05
$18.811,14
$18.587,84
$18.366,16
$18.146,10
$17.927,67

120
$11.778,64
$11.526,12
$11.276,67
$11.030,31
$10.787,06
$10.546,95
$10.310,00
$10.076,22

180
$9.355,03
$9.078,69
$8.806,62
$8.538,87
$8.275,52
$8.016,64
$7.762,29
$7.512,54

240
$8.244,32
$7.946,18
$7.653,14
$7.365,34
$7.082,94
$6.806,10
$6.534,93
$6.269,58

300
$7.649,66
$7.332,25
$7.020,42
$6.714,40
$6.414,47
$6.120,86
$5.833,83
$5.553,61

360
$7.304,68
$6.970,76
$6.642,54
$6.320,37
$6.004,65
$5.695,73
$5.394,00
$5.099,81

Projected Income Statement Model
Sales

0
1
2
3
4
5
6
7
8
9
10
11
$ 125.000 $ 137.500 $ 151.250 $ 166.375 $ 183.013 $ 201.314 $ 221.445 $ 243.590 $ 267.949 $ 294.743 $ 324.218 $ 356.640

Expenses:
Costs related to sales
Costs unrelated to sales
Total Expense
Gross Profit/Loss

108.750
40.000
148.750
$

Required Sales Growth
Costs related to sales as % of Sales
Month
Percent growth
Sales
Costs related to sales %
Fixed costs
Gross Profit/Loss

119.625
40.000
159.625

131.588
40.000
171.588

144.746
40.000
184.746

159.221
40.000
199.221

175.143
40.000
215.143

192.657
40.000
232.657

211.923
40.000
251.923

233.115
40.000
273.115

256.427
40.000
296.427

(23.750) $ (22.125) $ (20.338) $ (18.371) $ (16.208) $ (13.829) $ (11.212) $ (8.333) $ (5.167) $ (1.683) $

282.069
40.000
322.069
2.148

310.276
40.000
350.276
$

6.363

10%
87%

$

$

6
10%
222.013
82%
40.000
(0)

20210416070216thompson_excel_comp_cap1_winter_revenue

Idaho Store

Front Range Action Sports
Apparel Costs
All Stores

Mt. Rainier Coats
Mt. Baker Coats
Mt. Hood Coats
Mt. Adams Coats
Mt. Baldy Coats
Stormy Weather Pants
Mountain Rain Pants
Venture Pants
Snowy River Pants
Marmot Mountain Pants
Women's Hats
Men's Hats
Gloves
Total by Quarter

1st Qtr
2nd Qtr
3rd Qtr
4th Qtr
13.155 $ 12.554 $ 12.554 $
1.824
12.486
11.846
13.968
1.538
11.354
11.522
11.752
11.856
11.498
12.898
13.298
11.093
12.570
11.320
11.319
13.474
12.129
12.221
12.323
13.223
13.226
14.114
15.218
11.316
17.110
18.548
19.283
19.962
11.220
12.250
14.358
14.498
11.200
11.695
12.315
13.275
11.189
11.183
11.213
11.368
11.943
11.234
12.147
11.198
6.176
6.986
10.146
12.248
$ 155.256 $ 158.371 $ 169.894 $ 146.873

$

Apparel Costs
Annual Costs for All Stores
Coat Costs
Pant Costs
Headwear Costs
Glove Costs
Total

$ 223.879
279.484
91.475
35.556
$ 630.394

20210416070216thompson_excel_comp_cap1_winter_revenue

Quarterly Apparel Costs

Sub Report_Title()
'
' Report_Title Macro
' Report Heading
'
' Keyboard Shortcut: Ctrl+o
'
Selection.FormulaR1C1 =
"Front Range Action
Sports"
Range("A1:E1").Select
Range("E1").Activate
With Selection
.HorizontalAlignment =
xlCenter
.VerticalAlignment =
xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder =
xlContext
.MergeCells = False
End With
Selection.Merge
Selection.Style = "Title"

20210416070216thompson_excel_comp_cap1_winter_revenue

Quarterly Apparel Costs

Front Range Action Sports
Product List
Style Code
C-AD
C-BK
C-HD
C-RR
P-MR
P-SR
P-VT

Description
Mt. Adams coat
Mt. Baker coat
Mt. Hood coat
Mt. Rainier coat
Mountain Rain pant
Snowy River pant
Venture pant

20210416070216thompson_excel_comp_cap1_winter_revenue

Unit Price
$
325,00
$
333,00
$
359,00
$
316,00
$
140,00
$
125,00
$
157,00

Product Information

Front Range Action Sports
Phone Order Form
Custome...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Related Tags