I need to know how to calculated the loan and the loan payment from the graph above. specifically I need to know much the loan is and how much is need to be payed every month.
Opening Month May Additional Cash Reserves $16,000 ITEM PRICE COST DEMAND Hot Dogs $4.50 $1.24 3/4 Burgers $6.00 $2.95 2/3 Fries $2.50 $1.25 5/8 Drinks $1.95 $0.95 1/1 Hours daily (T-F) 8 Hourly customers (T-F) 11 Hours daily (S-S) 12 Hourly customers (S-S) 16 Employees (T-F) 1 Employees (T-F) 2 EXPENSE MONTHLY Mgr. Yearly $45,000 Kiosk Monthly Rent $4500 Asst. Yearly $30,000 Electricity Monthly $389 Hourly Wage $9.75 Advertising Monthly $800 Growth Rate 2.15% Telecom Monthly $250 Winter Sales Decrease 45% Insurance Monthly $355 Summer Sales Increase 75% Owner's Equity $20,000 Tax Rate 30% Kitchen Equipment $4150 POS System $4100 Initial Inventory $5200 Initial Ads $1900 Store Fixtures $6195 Licenses $3300 Rent Deposit $3000 Initial Insurance $475 Weeks in a Month 4.2 Loan APR% and Term 8.5% 6 Years Marketing Additional $1100 Marketing Additional 3 Advertising Expense Customers per hour Beer License $3500 Beer Insurance increase $400 Beer Demand 1/3 Beer Cost $4.00 Beer Price $7.00 Every Beer sold decreases Soda sales by 1 except on Sunday when no Beer is sold Resources: to search O RI I * Cut Da Copy Arial - 110 Wrap Text GO AA== 2.9.A. Ez Paste USD BIU- Merge & Center $ Format Painter Clipboard Font Alignment D11 X D Beer B 1 Original Recommendation Marketing 2 Start Up Costs: 3 4 Kitchen Equipment $ 4,150 5 Cash register and CC machine $ 4,100 6 Initial inventory (replenished as used). $ 5,200 7 Pre-opening advertising - $ 1,900 8 Store fixtures (counter, chairs, tables etc.) $ 6,195 9 Licenses $ 3,300 10 Rent deposit s 3,000 11 First Insurance payment $ 475 12 Total $ 28,320 13 14 Owner's Equity $ 20.000 15 Additional Cash Reserves $ 16,000 16 Calculated Ending Loan Amount 17 Beginning Cash Flow Balance 18 19 20 Assumptions Startup Costs Cash Pro-forma Budget Enter FH Type here to search 4 work page Monthly Revenue -1_ts IC Ai-lettag # All # [Keeng at it it, sed 1 - EM LI Help Tell me what you want to de I la morgan o De Page Layout Formula Date Red Times New Roma A A Cut Copy ormat Painter Number BIU- - Merge Center - $. *** InDelete for Conditional formats Cell Formatting Table Styles Styles Sort & Find a Cle and Font Algement Cli Editing 1 X D Mowth Month 2 Month ) Mesh Meet Month 6 Month 7 Month Month Meeth 10 Month 12 Hot Dog Hasbarers French Fries 10,42280 12,36480 483000 6,02784 33.655.44 55% 18,510.49 10 657 11 12,610 61 4,91133 6,15744 34379.04 35% 18.00 10.886 23 1229020 5,089 92 6,289 2 35,118.17 100% 35,118.17 11,120.29 11.119.60 5,18828 6,42506 35,87323 1001 35,873 23 11,359.37 13.462 5.25897 6.563,19 36,664.49 100, 3666449 11,603.60 13,79241 5,37204 6,70030 37,47235 175% 65,506,61 14.15013 5,41754 6.148.45 12,10792 14,350.30 5.6052 6,99567 39,009.41 1794 6,353.97 12,368024 14,658 65 5,726.04 7,146 09 39,299 02 100% 39 89902 onthly 12,61416 14973 $ 149 15 7.299.73 3079685 100 49,256.33 12,905.79 15,295 25 5,914.90 145661 41.633.12 100% 41 633 12 1311126 1309461 6 101 16 7.616.99 422522 38,519.20 TAL REVENUE 67,443.60 23,990.52 COGS 105 1430582 143052 55% 7,568 20 55% 7,568 20 14.300.82 100% 14,105.82 1430532 100% 14,30582 1402 100% 14,303.82 14305.82 1259 25,035.19 1430582 17% 25,035.19 1430530 1799 25.035 19 1430512 100 14.08.12 100 1430.82 100 14.3052 TOTAL COGS 14.30382 7,86820 Rest Phone Electricity 450000 250.00 4.500.00 250.00 4,500.00 150.00 4,500.00 250.00 399.00 355.00 800.00 4,500.00 25000 319 00 335 00 800.00 450000 250.00 389.00 355.00 30000 4.500.00 25000 389.00 355.00 800.00 450000 25000 38900 355.00 30000 4.500.00 250.00 389.00 35500 800.00 4,500.00 250.00 38900 35500 800.00 4.5000 250.00 319.00 355.00 500.00 355.00 30000 355.00 500.00 389.00 35500 300.00 155.00 800.00 Advertising Hourly Wars 3.276.00 6.250.00 3.276.00 6,250,00 3.276.00 6,250.00 3.276.00 6.250,00 3.276.00 6.950.00 3.276.00 6.250.00 3.276.00 3.276.00 6.250.00 3,27600 6.250.00 3276.00 6.25000 3.27600 6.250.00 3,27600 6,250.00 Las Payment L EXPENSES Assumptions Startup Costs Cash Proforma Budget work page Monthly Revenue Net 4 M 343 AM 9/27/2020 RI ype here to search F
