Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    Funding Proj. For Startups

    Uploaded by

    Biki Bhai
    The document shows funding projections for XYZ Company over 5 years including equity, debt, interest rates, interest expense, interest income, retained earnings, and dividends. It provides financial details on the company's beginning cash, equity funding rounds, short and long term debt, interest rates and expenses, net income, retained earnings, and ending cash for each year.

    Copyright:

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

    Funding Proj. For Startups

    Uploaded by

    Biki Bhai
    11 views5 pages
    The document shows funding projections for XYZ Company over 5 years including equity, debt, interest rates, interest expense, interest income, retained earnings, and dividends. It provides financial details on the company's beginning cash, equity funding rounds, short and long term debt, interest rates and expenses, net income, retained earnings, and ending cash for each year.

    Original Description:

    Funding proj for startups

    Original Title

    Funding proj. for startups

    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 shows funding projections for XYZ Company over 5 years including equity, debt, interest rates, interest expense, interest income, retained earnings, and dividends. It provides financial details on the company's beginning cash, equity funding rounds, short and long term debt, interest rates and expenses, net income, retained earnings, and ending cash for each year.

    Copyright:

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

    Funding Proj. For Startups

    Uploaded by

    Biki Bhai
    The document shows funding projections for XYZ Company over 5 years including equity, debt, interest rates, interest expense, interest income, retained earnings, and dividends. It provides financial details on the company's beginning cash, equity funding rounds, short and long term debt, interest rates and expenses, net income, retained earnings, and ending cash for each year.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 5

    XYZ Company

    Funding Projections
    Years 1 to 5
    ($)
    Begin Year 1 Year 2 Year 3 Year 4
    Beginning Cash 1,500,000
    Equity
    Common 500,000 500,000 500,000 500,000 500,000
    Increase / (Decrease) Previous Period 0 0 0 0
    Preferred
    A Round 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000
    B Round 500,000 500,000 500,000
    Total Preferred 1,000,000 1,000,000 1,500,000 1,500,000 1,500,000
    Increase / (Decrease) Previous Period 0 500,000 0 0
    Total Equity 1,500,000 1,500,000 2,000,000 2,000,000 2,000,000

    Debt
    Short Term Debt 100,000
    Increase / (Decrease) Previous Period 0 0 0 100,000

    Long Term Debt


    Current Portion 100,000 100,000 100,000
    Long Term Portion 400,000 300,000 200,000
    Total Long Term Debt 0 500,000 400,000 300,000

    Increase / (Decrease) Previous Period


    Current Portion 0 100,000 0 0
    Long Term Protion 0 400,000 (100,000) (100,000)
    Total Long Term Debt 0 500,000 (100,000) (100,000)

    Total Equity & Debt 1,500,000 1,500,000 2,500,000 2,400,000 2,400,000

    Interest
    Interest Rate
    Short Term Debt 9.0% 9.0% 9.0% 9.0%
    Long Term Debt 12.0% 12.0% 12.0% 12.0%

    Interest Expense
    Short Term Debt 0 0 0 9,000
    Long Term Debt 0 60,000 48,000 36,000
    Total Interest 0 60,000 48,000 45,000

    Interest Income
    Interest Rate 4.0% 4.0% 4.0% 4.0%
    Interest Income 0 0 0 0

    Retained Earnings
    Net Income (712,131) (218,064) 704,515 1,002,741
    Dividends
    Increase / (Decrease) Retained Earnings (712,131) (218,064) 704,515 1,002,741
    Beginning Retained Earnings 0 (712,131) (930,195) (225,681)
    Ending Retained Earnings (712,131) (930,195) (225,681) 777,060
    Notes

    Year 5

    500,000
    0

    1,000,000
    500,000
    1,500,000
    0
    2,000,000

    (100,000)

    100,000
    100,000
    200,000

    0
    (100,000)
    (100,000)

    2,200,000

    9.0%
    12.0%

    0
    24,000
    24,000

    4.0%
    10,000

    2,252,034
    50,000
    2,202,034
    777,060
    2,979,094

    Note: total expenses for the year


    must equal the annual projections
    above.

    Note: total expenses for the year


    must equal the annual projections
    above.
    Note: total expenses for the year
    must equal the annual projections
    above.

    You might also like