How to find the followings:
Net income before tax?
Cash flow?
Net income?
AutoSave Off be ALSAFFAR, FERAS, FA.xlsx - Excel 1 Sign in File Home Insert Draw Page Layout Formulas Data Review View Help O Search Share Comments J40 B 0 P Q 10 11 monthly revenue: seasonal adjustment: Total revenue: D E F G $154,669.00 $156,929.21 $ 158,559.90 $160,541.90 $162,548.66 -$88,298.04 -$89,401.77 $154,669.00 $156,929.21 $158,559.90 $72,243.86 $73,146.89 . 1 j K L M N $164,580.52 $166,637.78 $168,720.75 $170,829.76 $172,965.13 $175,127.20 $177,316.29 - $90,519.29 $51,248.93 $51,889.54 $52,538.16 $ 74,061.23 $166,637.78 $168,720.75 $222,078.69 $224,854.67 $227,665.36 $177,316.29 12 13 $97,611.12 $98,831.26 $100,066.65 $101,317.48 $102,583.95 - $55,724.62 -$56,421.17 $98,831.26 $100,066.65 $45,592.86 $46,162.78 $103,866.25 -$57,126.44 $46,739.81 $105,164.58 $106,479.14 $107,810.13 $109,157.75 $110,522.22 $111,903.75 $32,343.04 $32,747.33 $33,156.67 $105,164.58 $106,479.14 $140,153.17 $141,905.08 $143,678.89 $111,903.75 $97,611.12 14 15 Expenses: 16 17 cost of services sold: 18 seasonal adjustment: 19 total coss: 20 21 Fixed Expenses: 22 Rent 23 Phone/Internet 24 Electricty 25 Insurance 26 Adversiting/Promotion 27 Advertisment Contract 28 $7,150.00 $106.00 $450.00 $ 792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $ 792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $ 792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 29 30 31 32 33 Labor Costs: hourly wages: salaried wages: $11,109.00 $6,645.83 $11,109.00 $11,109.00 $11,109.00 $6,645.83 $6,645.83 $6,645.83 $11,109.00 $6,645.83 $11,109.00 $6,645.83 $11,109.00 $6,645.83 $11,109.00 $6,645.83 $ $11,109.00 $6,645.83 $11,109.00 $6,645.83 $11,109.00 $6,645.83 $11,109.00 $6,645.83 loan payment: $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 34 35 36 Total expenses: $126,595.01 $127,815.15 $129,050.54 $74,576.75 $75,146.67 $75,723.70 $134,148.47 $135,463.03 $169,137.06 $170,888.97 $172,662.78 $140,887.64 37 38 net income before tax: $30,073.99 $30,787.21 $31,509.35 - $332.91 $0.23 $337.53 $34,489.31 $54,941.63 $55,965.70 $57,002.57 $38,428.64 39 40 41 tax: $8,119.98 $8,312.55 $8,507.52 -$89.89 $0.06 $91.13 $9,312.11 $14,834.24 $15,110.74 $15,390.69 $10,375.73 net income: 42 43 44 cash flow : 45 Data Startup Baseline (+ + 100% H. W s PC 4:00 AM 10/19/2020 AutoSave Off be ALSAFFAR, FERAS, FA.xlsx - Excel 1 Sign in File Home Insert Draw Page Layout Formulas Data Review View Help O Search Share Comments J40 B 0 P Q 10 11 monthly revenue: seasonal adjustment: Total revenue: D E F G $154,669.00 $156,929.21 $ 158,559.90 $160,541.90 $162,548.66 -$88,298.04 -$89,401.77 $154,669.00 $156,929.21 $158,559.90 $72,243.86 $73,146.89 . 1 j K L M N $164,580.52 $166,637.78 $168,720.75 $170,829.76 $172,965.13 $175,127.20 $177,316.29 - $90,519.29 $51,248.93 $51,889.54 $52,538.16 $ 74,061.23 $166,637.78 $168,720.75 $222,078.69 $224,854.67 $227,665.36 $177,316.29 12 13 $97,611.12 $98,831.26 $100,066.65 $101,317.48 $102,583.95 - $55,724.62 -$56,421.17 $98,831.26 $100,066.65 $45,592.86 $46,162.78 $103,866.25 -$57,126.44 $46,739.81 $105,164.58 $106,479.14 $107,810.13 $109,157.75 $110,522.22 $111,903.75 $32,343.04 $32,747.33 $33,156.67 $105,164.58 $106,479.14 $140,153.17 $141,905.08 $143,678.89 $111,903.75 $97,611.12 14 15 Expenses: 16 17 cost of services sold: 18 seasonal adjustment: 19 total coss: 20 21 Fixed Expenses: 22 Rent 23 Phone/Internet 24 Electricty 25 Insurance 26 Adversiting/Promotion 27 Advertisment Contract 28 $7,150.00 $106.00 $450.00 $ 792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $ 792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $ 792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 $7,150.00 $106.00 $450.00 $792.00 $195.00 $2,000.00 29 30 31 32 33 Labor Costs: hourly wages: salaried wages: $11,109.00 $6,645.83 $11,109.00 $11,109.00 $11,109.00 $6,645.83 $6,645.83 $6,645.83 $11,109.00 $6,645.83 $11,109.00 $6,645.83 $11,109.00 $6,645.83 $11,109.00 $6,645.83 $ $11,109.00 $6,645.83 $11,109.00 $6,645.83 $11,109.00 $6,645.83 $11,109.00 $6,645.83 loan payment: $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 $536.06 34 35 36 Total expenses: $126,595.01 $127,815.15 $129,050.54 $74,576.75 $75,146.67 $75,723.70 $134,148.47 $135,463.03 $169,137.06 $170,888.97 $172,662.78 $140,887.64 37 38 net income before tax: $30,073.99 $30,787.21 $31,509.35 - $332.91 $0.23 $337.53 $34,489.31 $54,941.63 $55,965.70 $57,002.57 $38,428.64 39 40 41 tax: $8,119.98 $8,312.55 $8,507.52 -$89.89 $0.06 $91.13 $9,312.11 $14,834.24 $15,110.74 $15,390.69 $10,375.73 net income: 42 43 44 cash flow : 45 Data Startup Baseline (+ + 100% H. W s PC 4:00 AM 10/19/2020
