ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
Modern Music Shops
Six-Month Financial Projection 3/30/2016
July
August
Septem
ber
O
ctober
Novem
ber
Decem
ber
Total
Chart
Revenue $3,113,612.16 $7,962,235.53 $5,112,268.58 $2,924,627.87 $7,630,534.65 $3,424,270.23 $30,167,549.02
Cost of Goods Sold 1,323,285.17 3,383,950.10 2,172,714.15 1,242,966.84 3,242,977.23 1,455,314.85 12,821,208.33
Gross Margin 1,790,326.99$ 4,578,285.43$ 2,939,554.43$ 1,681,661.03$ 4,387,557.42$ 1,968,955.38$ 17,346,340.69$
Expenses
Bonuses $0.00 $200,000.00 $200,000.00 $0.00 $200,000.00 $0.00 $600,000.00
Commission 179,032.70 457,828.54 293,955.44 168,166.10 438,755.74 196,895.54 1,734,634.07
Marketing 467,041.82 1,194,335.33 766,840.29 438,694.18 1,144,580.20 513,640.53 4,525,132.35
Research and Development 233,520.91 597,167.66 383,420.14 219,347.09 572,290.10 256,820.27 2,262,566.18
Support, General, and Administrative 583,802.28 1,492,919.16 958,550.36 548,367.73 1,430,725.25 642,050.67 5,656,415.44
Total Expenses 1,463,397.72$ 3,942,250.70$ 2,602,766.23$ 1,374,575.10$ 3,786,351.29$ 1,609,407.01$ 14,778,748.04$
Operating Income 326,929.28$ 636,034.73$ 336,788.20$ 307,085.93$ 601,206.14$ 359,548.37$ 2,567,592.65$
July
13%
August
25%
September
13%
October
12%
November
23%
December
14%
Six-Month Financial Projection
Allentown Chamber City Pattonsville Sable Villiage Strongville Town of Cary Total
Corporate 74,029.35$ 92,278.21$ 63,081.74$ 84,210.02$ 61,644.26$ 89,820.51$ 465,064.09$
Direct Mail 67,286.06 83,867.23 55,076.48 55,547.28 79,779.02 84,366.19 425,922.26
Fun Runs 54,704.39 66,934.67 64,581.66 28,895.86 32,690.37 64,242.72 312,049.67
Government 30,623.99 58,614.35 51,486.46 36,387.09 51,642.55 40,177.87 268,932.31
Phone-a-thon 16,692.14 24,223.81 9,492.91 17,328.74 12,305.85 21,097.60 101,141.05
Total 243,335.93$ 325,918.27$ 243,719.25$ 222,368.99$ 238,062.05$ 299,704.89$ 1,573,109.38$
Lifetime Fundraising Summary
$-
$10,000.00
$20,000.00
$30,000.00
$40,000.00
$50,000.00
$60,000.00
$70,000.00
$80,000.00
$90,000.00
$100,000.00
Allentown Chamber City Pattonsville Sable Villiage Strongville Town of Cary
Corporate
Direct Mail
Fun Runs
Government
Phone-a-thon
Employee Hire Date Dependents
Hours
Worked
Hourly
Pay Rate Gross Pay Federal Tax State Tax Net Pay Tax %
Charvat, Emily 3/ 3/ 09 1 65.25 20.50$ 1,337.63$ 288.93$ 53.51$ 995.19$ 25.60%
Chen, Bin 6/ 14/ 10 2 80.00 25.85 2,068.00 444.26 82.72 1,541.02 25.48%
Felski, Noah 10/ 11/ 08 0 64.50 12.60 812.70 178.79 32.51 601.40 26.00%
Kersey, Jane 3/ 4/ 11 1 68.50 21.45 1,469.33 317.90 58.77 1,092.65 25.64%
Merna, Thomas 1/ 15/ 10 3 78.25 22.60 1,768.45 373.01 70.74 1,324.70 25.09%
Pollitt, Sherry 11/ 15/ 08 2 49.25 18.25 898.81 187.04 35.95 675.82 24.81%
Prasad, Rao 2/ 15/ 08 0 33.50 9.35 313.23 68.91 12.53 231.79 26.00%
Washington, Yolanda 5/ 11/ 06 2 79.25 23.75 1,882.19 403.38 75.29 1,403.52 25.43%
Zinca, James 4/ 14/ 11 1 80.00 19.65 1,572.00 340.49 62.88 1,168.63 25.66%
Totals 598.50 12122.33 2602.71 484.893 9034.73 25.47%
Average 1.333333333 66.50 $19.33 $1,346.93 $289.19 $53.88 $1,003.86
Highest 3 80.00 $25.85 $2,068.00 $444.26 $82.72 $1,541.02 26.00%
Lowest 0 33.50 $9.35 $313.23 $68.91 $12.53 $231.79 24.81%
The Mobile Masses Store
Biweekly Payroll Report

More Related Content

What's hot (17)

Corporate Factsheet October 31, 2012
Corporate Factsheet October 31, 2012Corporate Factsheet October 31, 2012
Corporate Factsheet October 31, 2012
Stornoway Diamonds
Ìý
2007 Summer
2007 Summer2007 Summer
2007 Summer
Ryan Kennedy
Ìý
Alor Grande, Goa
Alor Grande, GoaAlor Grande, Goa
Alor Grande, Goa
Sunil Gulati
Ìý
K 3-b=m.yusuf(18),wisnu(29),dwi may (10) bayu s (5)new
K 3-b=m.yusuf(18),wisnu(29),dwi may (10) bayu s (5)newK 3-b=m.yusuf(18),wisnu(29),dwi may (10) bayu s (5)new
K 3-b=m.yusuf(18),wisnu(29),dwi may (10) bayu s (5)new
wisnu_bayu
Ìý
Excel presentation
Excel presentationExcel presentation
Excel presentation
Maddy
Ìý
WRITE UP
WRITE UPWRITE UP
WRITE UP
Sattwik Ghosh
Ìý
Investment Charity Flyer
Investment Charity FlyerInvestment Charity Flyer
Investment Charity Flyer
guestb00f48
Ìý
Portafolio de Servicios MN
Portafolio de Servicios MNPortafolio de Servicios MN
Portafolio de Servicios MN
manosamigaspdf
Ìý
Lock out 1
Lock out 1Lock out 1
Lock out 1
Jack Harbour
Ìý
Payroll
PayrollPayroll
Payroll
DE Prof. Nilda Santiago Lebron
Ìý
Bagoes1 excel
Bagoes1 excelBagoes1 excel
Bagoes1 excel
bagoes putra
Ìý
Planificacion de procesos
Planificacion de procesosPlanificacion de procesos
Planificacion de procesos
Esteban Ardila Valencia
Ìý
Annonce Westmount Independent
Annonce Westmount IndependentAnnonce Westmount Independent
Annonce Westmount Independent
martinrouleau
Ìý
Fy summary by manager 04052010
Fy summary by manager 04052010Fy summary by manager 04052010
Fy summary by manager 04052010
Jason2001
Ìý
G traffic september2012_mobile_webistes
G traffic september2012_mobile_webistesG traffic september2012_mobile_webistes
G traffic september2012_mobile_webistes
Dani_Blazheva_Gemius
Ìý
Angus com facilidade e crescimento
Angus com facilidade e crescimentoAngus com facilidade e crescimento
Angus com facilidade e crescimento
Abs Pecplan
Ìý
Situacao Actual da Carteira Crédito FONDO 2
Situacao Actual da Carteira Crédito FONDO 2Situacao Actual da Carteira Crédito FONDO 2
Situacao Actual da Carteira Crédito FONDO 2
fondo microcredito
Ìý
Corporate Factsheet October 31, 2012
Corporate Factsheet October 31, 2012Corporate Factsheet October 31, 2012
Corporate Factsheet October 31, 2012
Stornoway Diamonds
Ìý
Alor Grande, Goa
Alor Grande, GoaAlor Grande, Goa
Alor Grande, Goa
Sunil Gulati
Ìý
K 3-b=m.yusuf(18),wisnu(29),dwi may (10) bayu s (5)new
K 3-b=m.yusuf(18),wisnu(29),dwi may (10) bayu s (5)newK 3-b=m.yusuf(18),wisnu(29),dwi may (10) bayu s (5)new
K 3-b=m.yusuf(18),wisnu(29),dwi may (10) bayu s (5)new
wisnu_bayu
Ìý
Excel presentation
Excel presentationExcel presentation
Excel presentation
Maddy
Ìý
Investment Charity Flyer
Investment Charity FlyerInvestment Charity Flyer
Investment Charity Flyer
guestb00f48
Ìý
Portafolio de Servicios MN
Portafolio de Servicios MNPortafolio de Servicios MN
Portafolio de Servicios MN
manosamigaspdf
Ìý
Bagoes1 excel
Bagoes1 excelBagoes1 excel
Bagoes1 excel
bagoes putra
Ìý
Annonce Westmount Independent
Annonce Westmount IndependentAnnonce Westmount Independent
Annonce Westmount Independent
martinrouleau
Ìý
Fy summary by manager 04052010
Fy summary by manager 04052010Fy summary by manager 04052010
Fy summary by manager 04052010
Jason2001
Ìý
G traffic september2012_mobile_webistes
G traffic september2012_mobile_webistesG traffic september2012_mobile_webistes
G traffic september2012_mobile_webistes
Dani_Blazheva_Gemius
Ìý
Angus com facilidade e crescimento
Angus com facilidade e crescimentoAngus com facilidade e crescimento
Angus com facilidade e crescimento
Abs Pecplan
Ìý
Situacao Actual da Carteira Crédito FONDO 2
Situacao Actual da Carteira Crédito FONDO 2Situacao Actual da Carteira Crédito FONDO 2
Situacao Actual da Carteira Crédito FONDO 2
fondo microcredito
Ìý

Viewers also liked (8)

Estrategias de apendizajeEstrategias de apendizaje
Estrategias de apendizaje
USAC
Ìý
412. historia e importancia del convento 412. historia e importancia del convento
412. historia e importancia del convento
dec-admin2
Ìý
Maestría en Educación Básica Portafolio de evidenciasMaestría en Educación Básica Portafolio de evidencias
Maestría en Educación Básica Portafolio de evidencias
Universidad Pedagógica Nacional México
Ìý
Cédula de supervisión_a_los_docentes_sep2015Cédula de supervisión_a_los_docentes_sep2015
Cédula de supervisión_a_los_docentes_sep2015
alealmeida
Ìý
Propuesta para supervisión_sep2015Propuesta para supervisión_sep2015
Propuesta para supervisión_sep2015
alealmeida
Ìý
Guia operativa para escuelas públicas 2015   2016Guia operativa para escuelas públicas 2015   2016
Guia operativa para escuelas públicas 2015 2016
alealmeida
Ìý
La institucion educativaLa institucion educativa
La institucion educativa
Ivonnezevahc
Ìý
Portafolio (Maestría en Formación Docente)Portafolio (Maestría en Formación Docente)
Portafolio (Maestría en Formación Docente)
USAC
Ìý
Estrategias de apendizajeEstrategias de apendizaje
Estrategias de apendizaje
USAC
Ìý
412. historia e importancia del convento 412. historia e importancia del convento
412. historia e importancia del convento
dec-admin2
Ìý
Maestría en Educación Básica Portafolio de evidenciasMaestría en Educación Básica Portafolio de evidencias
Maestría en Educación Básica Portafolio de evidencias
Universidad Pedagógica Nacional México
Ìý
Cédula de supervisión_a_los_docentes_sep2015Cédula de supervisión_a_los_docentes_sep2015
Cédula de supervisión_a_los_docentes_sep2015
alealmeida
Ìý
Propuesta para supervisión_sep2015Propuesta para supervisión_sep2015
Propuesta para supervisión_sep2015
alealmeida
Ìý
Guia operativa para escuelas públicas 2015   2016Guia operativa para escuelas públicas 2015   2016
Guia operativa para escuelas públicas 2015 2016
alealmeida
Ìý
La institucion educativaLa institucion educativa
La institucion educativa
Ivonnezevahc
Ìý
Portafolio (Maestría en Formación Docente)Portafolio (Maestría en Formación Docente)
Portafolio (Maestría en Formación Docente)
USAC
Ìý

Similar to Excel Work (20)

chap3lab3
chap3lab3chap3lab3
chap3lab3
landiza
Ìý
chap3lab3
chap3lab3chap3lab3
chap3lab3
jonelgo
Ìý
mejares_chap3lab3
mejares_chap3lab3mejares_chap3lab3
mejares_chap3lab3
aiz_muah
Ìý
chap3lab3
chap3lab3chap3lab3
chap3lab3
jonelgo
Ìý
Graphs CHSZ
Graphs CHSZGraphs CHSZ
Graphs CHSZ
blanchardschool
Ìý
Graphs nnn
Graphs nnnGraphs nnn
Graphs nnn
blanchardschool
Ìý
Graphs 34
Graphs 34Graphs 34
Graphs 34
blanchardschool
Ìý
Graphs 12345 12345
Graphs 12345 12345Graphs 12345 12345
Graphs 12345 12345
blanchardschool
Ìý
Round 2Dec. 31, 2015 C57912AndrewsTracy CalhounVict.docx
Round 2Dec. 31, 2015 C57912AndrewsTracy CalhounVict.docxRound 2Dec. 31, 2015 C57912AndrewsTracy CalhounVict.docx
Round 2Dec. 31, 2015 C57912AndrewsTracy CalhounVict.docx
joellemurphey
Ìý
Graphs 4444565e5545454654545
Graphs 4444565e5545454654545Graphs 4444565e5545454654545
Graphs 4444565e5545454654545
blanchardschool
Ìý
Graphs 123456789 CHSZ
Graphs 123456789 CHSZGraphs 123456789 CHSZ
Graphs 123456789 CHSZ
blanchardschool
Ìý
Graphs 123456789 CHSZ
Graphs 123456789 CHSZGraphs 123456789 CHSZ
Graphs 123456789 CHSZ
blanchardschool
Ìý
SHIPPING DEPARTEMENT
SHIPPING DEPARTEMENTSHIPPING DEPARTEMENT
SHIPPING DEPARTEMENT
SuhariEte2
Ìý
Round 5Dec. 31, 2018 C58538AndrewsEugene EllisPhili.docx
Round 5Dec. 31, 2018 C58538AndrewsEugene EllisPhili.docxRound 5Dec. 31, 2018 C58538AndrewsEugene EllisPhili.docx
Round 5Dec. 31, 2018 C58538AndrewsEugene EllisPhili.docx
joellemurphey
Ìý
Tabla de Amortización de Préstamo
Tabla de Amortización de PréstamoTabla de Amortización de Préstamo
Tabla de Amortización de Préstamo
Ivan Villamizar
Ìý
OSCAR ALAN SEGURA RIVERA
OSCAR ALAN SEGURA RIVERAOSCAR ALAN SEGURA RIVERA
OSCAR ALAN SEGURA RIVERA
OSCAR SEGURA
Ìý
KPI Examples
KPI ExamplesKPI Examples
KPI Examples
Franky Huang
Ìý
Teacher Concessions
Teacher ConcessionsTeacher Concessions
Teacher Concessions
Melanie Kerber
Ìý
Okanagan Real Estate June 2021 Statistics
Okanagan Real Estate June 2021 Statistics Okanagan Real Estate June 2021 Statistics
Okanagan Real Estate June 2021 Statistics
Vicky Aulakh
Ìý
Profit analysis (zyra m sheet1
Profit analysis (zyra m sheet1Profit analysis (zyra m sheet1
Profit analysis (zyra m sheet1
maranan_zyra
Ìý
chap3lab3
chap3lab3chap3lab3
chap3lab3
landiza
Ìý
chap3lab3
chap3lab3chap3lab3
chap3lab3
jonelgo
Ìý
mejares_chap3lab3
mejares_chap3lab3mejares_chap3lab3
mejares_chap3lab3
aiz_muah
Ìý
chap3lab3
chap3lab3chap3lab3
chap3lab3
jonelgo
Ìý
Graphs 12345 12345
Graphs 12345 12345Graphs 12345 12345
Graphs 12345 12345
blanchardschool
Ìý
Round 2Dec. 31, 2015 C57912AndrewsTracy CalhounVict.docx
Round 2Dec. 31, 2015 C57912AndrewsTracy CalhounVict.docxRound 2Dec. 31, 2015 C57912AndrewsTracy CalhounVict.docx
Round 2Dec. 31, 2015 C57912AndrewsTracy CalhounVict.docx
joellemurphey
Ìý
Graphs 4444565e5545454654545
Graphs 4444565e5545454654545Graphs 4444565e5545454654545
Graphs 4444565e5545454654545
blanchardschool
Ìý
Graphs 123456789 CHSZ
Graphs 123456789 CHSZGraphs 123456789 CHSZ
Graphs 123456789 CHSZ
blanchardschool
Ìý
Graphs 123456789 CHSZ
Graphs 123456789 CHSZGraphs 123456789 CHSZ
Graphs 123456789 CHSZ
blanchardschool
Ìý
SHIPPING DEPARTEMENT
SHIPPING DEPARTEMENTSHIPPING DEPARTEMENT
SHIPPING DEPARTEMENT
SuhariEte2
Ìý
Round 5Dec. 31, 2018 C58538AndrewsEugene EllisPhili.docx
Round 5Dec. 31, 2018 C58538AndrewsEugene EllisPhili.docxRound 5Dec. 31, 2018 C58538AndrewsEugene EllisPhili.docx
Round 5Dec. 31, 2018 C58538AndrewsEugene EllisPhili.docx
joellemurphey
Ìý
Tabla de Amortización de Préstamo
Tabla de Amortización de PréstamoTabla de Amortización de Préstamo
Tabla de Amortización de Préstamo
Ivan Villamizar
Ìý
OSCAR ALAN SEGURA RIVERA
OSCAR ALAN SEGURA RIVERAOSCAR ALAN SEGURA RIVERA
OSCAR ALAN SEGURA RIVERA
OSCAR SEGURA
Ìý
KPI Examples
KPI ExamplesKPI Examples
KPI Examples
Franky Huang
Ìý
Teacher Concessions
Teacher ConcessionsTeacher Concessions
Teacher Concessions
Melanie Kerber
Ìý
Okanagan Real Estate June 2021 Statistics
Okanagan Real Estate June 2021 Statistics Okanagan Real Estate June 2021 Statistics
Okanagan Real Estate June 2021 Statistics
Vicky Aulakh
Ìý
Profit analysis (zyra m sheet1
Profit analysis (zyra m sheet1Profit analysis (zyra m sheet1
Profit analysis (zyra m sheet1
maranan_zyra
Ìý

Excel Work

  • 1. Modern Music Shops Six-Month Financial Projection 3/30/2016 July August Septem ber O ctober Novem ber Decem ber Total Chart Revenue $3,113,612.16 $7,962,235.53 $5,112,268.58 $2,924,627.87 $7,630,534.65 $3,424,270.23 $30,167,549.02 Cost of Goods Sold 1,323,285.17 3,383,950.10 2,172,714.15 1,242,966.84 3,242,977.23 1,455,314.85 12,821,208.33 Gross Margin 1,790,326.99$ 4,578,285.43$ 2,939,554.43$ 1,681,661.03$ 4,387,557.42$ 1,968,955.38$ 17,346,340.69$ Expenses Bonuses $0.00 $200,000.00 $200,000.00 $0.00 $200,000.00 $0.00 $600,000.00 Commission 179,032.70 457,828.54 293,955.44 168,166.10 438,755.74 196,895.54 1,734,634.07 Marketing 467,041.82 1,194,335.33 766,840.29 438,694.18 1,144,580.20 513,640.53 4,525,132.35 Research and Development 233,520.91 597,167.66 383,420.14 219,347.09 572,290.10 256,820.27 2,262,566.18 Support, General, and Administrative 583,802.28 1,492,919.16 958,550.36 548,367.73 1,430,725.25 642,050.67 5,656,415.44 Total Expenses 1,463,397.72$ 3,942,250.70$ 2,602,766.23$ 1,374,575.10$ 3,786,351.29$ 1,609,407.01$ 14,778,748.04$ Operating Income 326,929.28$ 636,034.73$ 336,788.20$ 307,085.93$ 601,206.14$ 359,548.37$ 2,567,592.65$ July 13% August 25% September 13% October 12% November 23% December 14% Six-Month Financial Projection
  • 2. Allentown Chamber City Pattonsville Sable Villiage Strongville Town of Cary Total Corporate 74,029.35$ 92,278.21$ 63,081.74$ 84,210.02$ 61,644.26$ 89,820.51$ 465,064.09$ Direct Mail 67,286.06 83,867.23 55,076.48 55,547.28 79,779.02 84,366.19 425,922.26 Fun Runs 54,704.39 66,934.67 64,581.66 28,895.86 32,690.37 64,242.72 312,049.67 Government 30,623.99 58,614.35 51,486.46 36,387.09 51,642.55 40,177.87 268,932.31 Phone-a-thon 16,692.14 24,223.81 9,492.91 17,328.74 12,305.85 21,097.60 101,141.05 Total 243,335.93$ 325,918.27$ 243,719.25$ 222,368.99$ 238,062.05$ 299,704.89$ 1,573,109.38$ Lifetime Fundraising Summary $- $10,000.00 $20,000.00 $30,000.00 $40,000.00 $50,000.00 $60,000.00 $70,000.00 $80,000.00 $90,000.00 $100,000.00 Allentown Chamber City Pattonsville Sable Villiage Strongville Town of Cary Corporate Direct Mail Fun Runs Government Phone-a-thon Employee Hire Date Dependents Hours Worked Hourly Pay Rate Gross Pay Federal Tax State Tax Net Pay Tax % Charvat, Emily 3/ 3/ 09 1 65.25 20.50$ 1,337.63$ 288.93$ 53.51$ 995.19$ 25.60% Chen, Bin 6/ 14/ 10 2 80.00 25.85 2,068.00 444.26 82.72 1,541.02 25.48% Felski, Noah 10/ 11/ 08 0 64.50 12.60 812.70 178.79 32.51 601.40 26.00% Kersey, Jane 3/ 4/ 11 1 68.50 21.45 1,469.33 317.90 58.77 1,092.65 25.64% Merna, Thomas 1/ 15/ 10 3 78.25 22.60 1,768.45 373.01 70.74 1,324.70 25.09% Pollitt, Sherry 11/ 15/ 08 2 49.25 18.25 898.81 187.04 35.95 675.82 24.81% Prasad, Rao 2/ 15/ 08 0 33.50 9.35 313.23 68.91 12.53 231.79 26.00% Washington, Yolanda 5/ 11/ 06 2 79.25 23.75 1,882.19 403.38 75.29 1,403.52 25.43% Zinca, James 4/ 14/ 11 1 80.00 19.65 1,572.00 340.49 62.88 1,168.63 25.66% Totals 598.50 12122.33 2602.71 484.893 9034.73 25.47% Average 1.333333333 66.50 $19.33 $1,346.93 $289.19 $53.88 $1,003.86 Highest 3 80.00 $25.85 $2,068.00 $444.26 $82.72 $1,541.02 26.00% Lowest 0 33.50 $9.35 $313.23 $68.91 $12.53 $231.79 24.81% The Mobile Masses Store Biweekly Payroll Report