Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    Treasury

    Uploaded by

    api-190360054
    This document provides a treasury forecast for YourBreakeven.com over 5 years. It shows projected cash flows on a monthly and quarterly basis, including cash inflows from total revenues and cash outflows for expenses like production costs, rent, wages, and taxes. The forecast tracks beginning and ending cash balances as well as the change in cash each period. Overall, cash balances increase over the 5-year period as total revenues exceed total expenses in each year.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Treasury

    Uploaded by

    api-190360054
    29 views3 pages
    This document provides a treasury forecast for YourBreakeven.com over 5 years. It shows projected cash flows on a monthly and quarterly basis, including cash inflows from total revenues and cash outflows for expenses like production costs, rent, wages, and taxes. The forecast tracks beginning and ending cash balances as well as the change in cash each period. Overall, cash balances increase over the 5-year period as total revenues exceed total expenses in each year.

    Original Title

    treasury

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides a treasury forecast for YourBreakeven.com over 5 years. It shows projected cash flows on a monthly and quarterly basis, including cash inflows from total revenues and cash outflows for expenses like production costs, rent, wages, and taxes. The forecast tracks beginning and ending cash balances as well as the change in cash each period. Overall, cash balances increase over the 5-year period as total revenues exceed total expenses in each year.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    29 views3 pages

    Treasury

    Uploaded by

    api-190360054
    This document provides a treasury forecast for YourBreakeven.com over 5 years. It shows projected cash flows on a monthly and quarterly basis, including cash inflows from total revenues and cash outflows for expenses like production costs, rent, wages, and taxes. The forecast tracks beginning and ending cash balances as well as the change in cash each period. Overall, cash balances increase over the 5-year period as total revenues exceed total expenses in each year.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 3

    WWW.YOURBREAKEVEN.

    COM

    TREASURY FORECAST
    YOURBREAKEVEN.COM

    Cash - Initial
    Cash Inflow
    TOTAL REVENUES
    Chase Bank
    Equity - Cash
    Total Cash Inflow
    Cash Outflow
    Production cost
    Rent & Utility
    General & Admin
    Wages & Salaries
    Legal costs
    Tax
    Investments in Property, Plant Equipment
    Investment in intangible assets
    Dividends
    Coupon Chase Bank
    Total Cash Outflow
    Cash - Final
    Var Cash

    Month 1

    Month 2

    Month 3

    35,000

    4,022

    2,934

    5,962

    5,962

    6,558
    0
    0
    6,558

    4,070
    2,500
    520
    0
    2,000

    Quarter 1

    YEAR 1
    Quarter 2
    Month 7

    Month 4

    Month 5

    Month 6

    35,000

    2,054

    1,404

    1,006

    2,054

    7,214
    0
    0
    7,214

    19,734
    0
    0
    19,734

    7,935
    0
    0
    7,935

    8,729
    0
    0
    8,729

    10,002
    0
    0
    10,002

    4,477
    2,500
    520
    0
    0

    4,925
    2,500
    520
    0
    0

    13,472
    7,500
    1,560
    0
    2,000

    5,417
    2,500
    520
    0
    0

    5,959
    2,500
    520
    0
    0

    26,000
    1,700

    0
    0

    0
    0

    26,000
    1,700

    0
    0

    150
    36,940

    149
    7,646

    149
    8,094

    448
    52,680

    4,022

    2,934

    2,054

    (30,978)

    (1,088)

    (880)

    EoY 1
    Month 8

    Month 9

    Quarter 3

    Month 10

    Month 11

    Month 12

    Quarter 4

    1,286

    1,871

    2,792

    1,286

    4,532

    6,679

    9,272

    4,532

    35,000

    26,666
    0
    0
    26,666

    10,962
    0
    0
    10,962

    12,018
    0
    0
    12,018

    13,630
    0
    0
    13,630

    36,610
    0
    0
    36,610

    14,908
    0
    0
    14,908

    16,314
    0
    0
    16,314

    17,860
    0
    0
    17,860

    49,082
    0
    0
    49,082

    132,093
    0
    0
    132,093

    6,555
    2,500
    520
    0
    0

    17,931
    7,500
    1,560
    0
    0

    7,210
    2,500
    520
    0
    0

    7,931
    2,500
    520
    0
    0

    8,724
    2,500
    520
    0
    0

    23,866
    7,500
    1,560
    0
    0

    9,597
    2,500
    520
    0
    0

    10,557
    2,500
    520
    0
    0

    11,612
    2,500
    520
    0
    0

    31,766
    7,500
    1,560
    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    147
    9,722

    443
    27,434

    147
    10,377

    146
    11,097

    146
    11,890

    438
    33,364

    145
    12,762

    144
    13,721

    144
    14,776

    433
    41,259

    87,034
    30,000
    6,240
    0
    2,000
    0
    26,000
    1,700
    0
    1,763
    154,737

    0
    0

    0
    0

    148
    8,586

    148
    9,127

    2,054

    1,404

    1,006

    1,286

    1,286

    1,871

    2,792

    4,532

    4,532

    6,679

    9,272

    12,356

    12,356

    12,356

    (32,946)

    (650)

    (398)

    280

    (768)

    585

    921

    1,740

    3,246

    2,146

    2,593

    3,084

    7,823

    (22,644)

    WWW.YOURBREAKEVEN.COM

    TREASURY FORECAST
    YOURBREAKEVEN.COM
    Month 1

    Month 2

    Month 3

    Cash - Initial

    12,356

    26,592

    45,756

    Cash Inflow
    TOTAL REVENUES
    Chase Bank
    Equity - Cash
    Total Cash Inflow

    29,737
    0
    0
    29,737

    38,268
    0
    0
    38,268

    12,017
    2,800
    540
    0
    0

    15,623
    2,800
    540
    0
    0

    0
    0

    0
    0

    143
    15,501

    Cash - Final
    Var Cash

    Cash Outflow
    Production cost
    Rent & Utility
    General & Admin
    Wages & Salaries
    Legal costs
    Tax
    Investments in Property, Plant Equipment
    Investment in intangible assets
    Dividends
    Coupon Chase Bank
    Total Cash Outflow

    Quarter 1

    YEAR 2
    Quarter 2 Month 7

    Month 4

    Month 5

    Month 6

    12,356

    66,896

    94,922

    132,011

    66,896

    49,359
    0
    0
    49,359

    117,365
    0
    0
    117,365

    63,777
    0
    0
    63,777

    82,520
    0
    0
    82,520

    108,086
    0
    0
    108,086

    47,949
    8,400
    1,620
    0
    0
    4,427
    0
    0
    0
    428
    62,825

    32,269
    2,800
    540
    0
    0

    41,950
    2,800
    540
    0
    0

    0
    0

    143
    19,105

    20,309
    2,800
    540
    0
    0
    4,427
    0
    0
    0
    142
    28,219

    26,592

    45,756

    66,896

    14,237

    19,163

    21,140

    EoY 2
    Month 8

    Month 9

    Quarter 3

    Month 10

    Month 11

    Month 12

    Quarter 4

    182,081

    236,706

    291,331

    182,081

    345,957

    400,584

    455,211

    345,957

    12,356

    254,382
    0
    0
    254,382

    117,505
    0
    0
    117,505

    117,505
    0
    0
    117,505

    117,505
    0
    0
    117,505

    352,515
    0
    0
    352,515

    117,505
    0
    0
    117,505

    117,505
    0
    0
    117,505

    117,505
    0
    0
    117,505

    352,515
    0
    0
    352,515

    1,076,777
    0
    0
    1,076,777

    54,535
    2,800
    540
    0
    0

    128,754
    8,400
    1,620
    0
    0

    59,400
    2,800
    540
    0
    0

    59,400
    2,800
    540
    0
    0

    59,400
    2,800
    540
    0
    0

    178,200
    8,400
    1,620
    0
    0

    59,400
    2,800
    540
    0
    0

    59,400
    2,800
    540
    0
    0

    59,400
    2,800
    540
    0
    0

    178,200
    8,400
    1,620
    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    142
    35,751

    141
    45,431

    141
    58,015

    423
    139,197

    140
    62,880

    139
    62,879

    139
    62,879

    418
    188,638

    138
    62,878

    138
    62,878

    137
    62,877

    413
    188,633

    533,103
    33,600
    6,480
    0
    0
    4,427
    0
    0
    0
    1,683
    579,294

    66,896

    94,922

    132,011

    182,081

    182,081

    236,706

    291,331

    345,957

    345,957

    400,584

    455,211

    509,839

    509,839

    509,839

    54,540

    28,026

    37,089

    50,070

    115,185

    54,625

    54,626

    54,626

    163,877

    54,627

    54,627

    54,628

    163,882

    497,483

    WWW.YOURBREAKEVEN.COM

    TREASURY FORECAST
    YOURBREAKEVEN.COM
    Quarter 1

    Year 3
    Quarter 2
    Quarter 3

    Quarter 4

    EoY 3
    Quarter 2

    YEAR 4
    Quarter 3

    Cash - Initial

    509,839

    318,313

    596,408

    874,508

    509,839

    1,152,613

    585,766

    908,221

    1,230,681

    1,152,613

    1,652,146

    951,641

    1,428,416

    1,869,196

    1,652,146

    Cash Inflow
    TOTAL REVENUES
    Chase Bank
    Equity - Cash
    Total Cash Inflow

    396,790
    0
    0
    396,790

    439,600
    0
    0
    439,600

    439,600
    0
    0
    439,600

    439,600
    0
    0
    439,600

    1,715,590
    0
    0
    1,715,590

    533,510
    0
    0
    533,510

    533,510
    0
    0
    533,510

    533,510
    0
    0
    533,510

    533,510
    0
    0
    533,510

    2,134,040
    0
    0
    2,134,040

    670,920
    0
    0
    670,920

    670,920
    0
    0
    670,920

    670,920
    0
    0
    670,920

    670,920
    0
    0
    670,920

    2,683,680
    0
    0
    2,683,680

    Cash Outflow
    Production cost
    Rent & Utility
    General & Admin
    Wages & Salaries
    Legal costs
    Tax
    Investments in Property, Plant Equipment
    Investment in intangible assets
    Dividends
    Coupon Chase Bank
    Total Cash Outflow

    135,000
    9,300
    1,800
    0
    0
    215,515
    0
    0
    226,291
    410
    588,316

    150,000
    9,300
    1,800
    0
    0

    150,000
    9,300
    1,800
    0
    0

    150,000
    9,300
    1,800
    0
    0

    198,000
    10,400
    2,270
    0
    0
    433,072
    1,500
    0
    454,726
    390
    1,100,358

    198,000
    10,400
    2,270
    0
    0

    198,000
    10,400
    2,270
    0
    0

    99,000
    10,400
    2,270
    0
    0

    162,000
    11,000
    2,780
    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    0
    0

    385
    211,055

    380
    211,050

    375
    112,045

    108,000
    11,000
    2,780
    0
    0
    567,852
    0
    0
    681,422
    370
    1,371,424

    216,000
    11,000
    2,780
    0
    0

    0
    0

    693,000
    41,600
    9,080
    0
    0
    433,072
    1,500
    0
    454,726
    1,530
    1,634,508

    180,000
    11,000
    2,780
    0
    0

    395
    161,495

    585,000
    37,200
    7,200
    0
    0
    215,515
    0
    0
    226,291
    1,610
    1,072,816

    365
    194,145

    360
    230,140

    355
    176,135

    666,000
    44,000
    11,120
    0
    0
    567,852
    0
    0
    681,422
    1,450
    1,971,844

    0
    0

    0
    0

    0
    0

    405
    161,505

    400
    161,500

    Cash - Final

    318,313

    596,408

    874,508

    1,152,613

    1,152,613

    585,766

    908,221

    1,230,681

    1,652,146

    1,652,146

    951,641

    1,428,416

    1,869,196

    2,363,981

    2,363,981

    Var Cash

    (191,526)

    278,095

    278,100

    278,105

    642,774

    (566,848)

    322,455

    322,460

    421,465

    499,532

    (700,504)

    476,775

    440,780

    494,785

    711,836

    Quarter 1

    EoY 4
    Quarter 4

    Quarter 1

    Quarter 2

    YEAR 5
    Quarter 3

    YEAR 5
    Quarter 4

    You might also like