Adrienne.Davis-EX2021-Capstone-Level1.xlsx

LoanAnalysis

Price $ 85,000.00
Loan term (in months) 36
Interest (annual) 3%
Monthly payment $ 2,471.90
Total payments
Interest paid

FoodTrucksTop't Corn Mobile Sal

Top't Corn Mobile Sales (August)
Truck Location
Crystal City Merrifield Lorton Ballston
Old Bay 3600 800 600 900
Truffle 4300 600 1500 1800
Sea Salt and Caramel 5300 1500 1400 1500

TysonsStore2022

Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold) Daily Total ($) Current price per box: $6
1-Aug 244 88 214 546 Daily sales goal: $2,400
2-Aug 230 190 82 502 Average daily sales:
3-Aug 50 170 161 381 Lowest daily sales:
4-Aug 245 98 182 525 Highest daily sales:
5-Aug 200 220 115 535
6-Aug 30 138 256 424
7-Aug 131 58 201 390
8-Aug 268 146 42 456
9-Aug 31 179 209 419
10-Aug 34 67 34 135
11-Aug 215 243 103 561
12-Aug 274 75 278 627
13-Aug 155 91 229 475
14-Aug 75 194 60 329
15-Aug 226 187 245 658
16-Aug 35 48 211 294
17-Aug 58 148 264 470
18-Aug 279 174 32 485
19-Aug 171 126 106 403
20-Aug 216 71 74 361
21-Aug 119 245 77 441
22-Aug 86 137 272 495
23-Aug 278 246 199 723
24-Aug 271 238 47 556
25-Aug 173 242 278 693
26-Aug 59 270 260 589
27-Aug 170 90 194 454
28-Aug 279 43 60 382
29-Aug 30 227 193 450
30-Aug 126 124 250 500
31-Aug 119 96 262 477