Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 250 views

    Business Plan Excel Template

    Uploaded by

    Firman Hananto
    The document provides a business plan and projected costs and revenues for a coffee cafe startup over its first year. It includes estimates for startup costs totaling $26,950 over 3-4 months, as well as monthly and annual projections for revenue, expenses, income, and net income over the first 12 months, with an estimated total net income of $14,040 for the year. Key expenses include employee salaries and payroll taxes, rent, marketing, and cost of goods sold.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Business Plan Excel Template

    Uploaded by

    Firman Hananto
    250 views3 pages
    The document provides a business plan and projected costs and revenues for a coffee cafe startup over its first year. It includes estimates for startup costs totaling $26,950 over 3-4 months, as well as monthly and annual projections for revenue, expenses, income, and net income over the first 12 months, with an estimated total net income of $14,040 for the year. Key expenses include employee salaries and payroll taxes, rent, marketing, and cost of goods sold.

    Original Description:

    Business Plan Excel Template

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides a business plan and projected costs and revenues for a coffee cafe startup over its first year. It includes estimates for startup costs totaling $26,950 over 3-4 months, as well as monthly and annual projections for revenue, expenses, income, and net income over the first 12 months, with an estimated total net income of $14,040 for the year. Key expenses include employee salaries and payroll taxes, rent, marketing, and cost of goods sold.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    250 views3 pages

    Business Plan Excel Template

    Uploaded by

    Firman Hananto
    The document provides a business plan and projected costs and revenues for a coffee cafe startup over its first year. It includes estimates for startup costs totaling $26,950 over 3-4 months, as well as monthly and annual projections for revenue, expenses, income, and net income over the first 12 months, with an estimated total net income of $14,040 for the year. Key expenses include employee salaries and payroll taxes, rent, marketing, and cost of goods sold.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 3

    Business Plan Excel Template

    Visit: www.educba.com

    Email: info@educba.com
    START-UP COSTS
    Coffee Cafe March 23, 2021

    COST ITEMS MONTHS COST/ MONTH ONE-TIME COST TOTAL COST


    Advertising/Marketing 3 $300 $2,000 $2,900
    Employee Salaries 4 $3,500 $2 $14,002
    Employee Payroll Taxes and Benefits 4 $500 $2,000 $4,000
    Rent/Lease Payments/Utilities 4 $750 $3,000 $6,000
    Postage/Shipping 1 $25 $25 $50
    START-UP COSTS
    Coffee Cafe March 23, 2021

    REVENUE JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD
    Estimated Product Sales $5,000 $13,000 $16,000 $7,000 $14,500 $16,400 $22,500 $23,125 $24,549 $22,000 $25,000 $27,349 $216,423
    Less Sales Returns & Discounts $0 ($350) $0 ($206) ($234) $0 $0 ($280) ($1,200) ($1,600) $0 ($2,400) ($6,270)
    Service Revenue $0 $0 $0 $0 $0 $250 $350 $100 $0 $0 $1,245 $1,360 $3,305
    Other Revenue $0 $0 $0 $0 $0 $0 $0 $1,500 $0 $0 $0 $0 $1,500
    Net Sales $5,000 $12,650 $16,000 $6,794 $14,266 $16,650 $22,850 $24,445 $23,349 $20,400 $26,245 $26,309 $214,958
    Cost of Goods Sold $2,000 $5,200 $6,400 $2,800 $5,800 $6,560 $9,000 $9,250 $9,820 $8,800 $10,000 $10,940 $86,569
    Gross Profit $3,000 $7,450 $9,600 $3,994 $8,466 $10,090 $13,850 $15,195 $13,529 $11,600 $16,245 $15,369 $128,389

    EXPENSES JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD
    Salaries & Wages $2,500 $2,500 $3,500 $5,000 $5,000 $5,000 $8,000 $9,000 $9,000 $9,000 $9,000 $9,000 $76,500
    Marketing/Advertising $400 $450 $450 $450 $900 $900 $900 $900 $900 $900 $1,200 $1,200 $9,550
    Sales Commissions $250 $650 $800 $350 $725 $820 $1,125 $1,156 $1,227 $1,100 $1,250 $1,367 $10,821
    Rent $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $15,000
    Total Expenses $4,400 $4,850 $6,000 $7,050 $7,875 $7,970 $11,275 $12,306 $12,377 $12,250 $12,700 $12,817 $111,871
    Income Before Taxes ($1,400) $2,600 $3,600 ($3,056) $591 $2,120 $2,575 $2,889 $1,152 ($650) $3,545 $2,552 $16,518
    Income Tax Expense ($210) $390 $540 ($458) $89 $318 $386 $433 $173 ($98) $532 $383 $2,478

    NET INCOME ($1,190) $2,210 $3,060 ($2,598) $502 $1,802 $2,189 $2,455 $979 ($553) $3,013 $2,169 $14,040

    You might also like