Scribd Logo
Upload

Welcome to Scribd!

  • 104 views

    911 BIZ201 Assessment 3 Student Workbook

    Uploaded by

    Akshita Chordia
    The document contains budgeted and actual cash flow information for operating, investing, and financing activities over multiple years. It compares the budgeted figures to actual results and identifies variances. There are also tables showing projections for investment returns over 10 years from a hotel project using net present value calculations at different discount rates.

    Copyright:

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

    911 BIZ201 Assessment 3 Student Workbook

    Uploaded by

    Akshita Chordia
    104 views7 pages
    The document contains budgeted and actual cash flow information for operating, investing, and financing activities over multiple years. It compares the budgeted figures to actual results and identifies variances. There are also tables showing projections for investment returns over 10 years from a hotel project using net present value calculations at different discount rates.

    Original Description:

    Finance

    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 contains budgeted and actual cash flow information for operating, investing, and financing activities over multiple years. It compares the budgeted figures to actual results and identifies variances. There are also tables showing projections for investment returns over 10 years from a hotel project using net present value calculations at different discount rates.

    Copyright:

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

    911 BIZ201 Assessment 3 Student Workbook

    Uploaded by

    Akshita Chordia
    The document contains budgeted and actual cash flow information for operating, investing, and financing activities over multiple years. It compares the budgeted figures to actual results and identifies variances. There are also tables showing projections for investment returns over 10 years from a hotel project using net present value calculations at different discount rates.

    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 7

    Budgeted Net cash flows from/ (used in) operating

    activities

    Budgeted Net cash flows from/ (used in) investing


    activities

    Budgeted Net cash flows from/ (used in) financing


    activities

    Budgeted Net increase/ (decrease) in cash and cash


    equivalents

    Budgeted Cash and cash equivalents at the end of the


    financial year
    Actual Net cash flows from/ (used in) operating Variance
    activities $m

    Actual Net cash flows from/ (used in) investing


    activities

    Actual Net cash flows from/ (used in) financing


    activities

    Actual Net increase/ (decrease) in cash and cash


    equivalents

    Actual Cash and cash equivalents at the end of the


    financial year
    Favourable/
    Unfavorable
    Year 0 Year 1 Year 2 Year 3 Year 4
    Investment [Initial
    Cost] of Hotel
    -15,000,000 - - - -
    Projected Cash Flow - 500,000 500,000 500,000 500,000
    Discount Rate 8% 1 0.92593 0.85734 0.79383 0.73503
    Present Value -15,000,000 462,965 428,670 396,915 367,515

    Year 0 Year 1 Year 2 Year 3 Year 4


    Investment [Initial Cost]
    40% of the PPE value Yes - - - -
    Projected Profit - Yes Yes Yes Yes
    Discount Rate 6% 1 0.9434 0.89 0.8396 0.7921
    Present Value Yes Yes Yes Yes Yes

    Investment [Initial Cost]


    40% of the PPE value -6000000 - - - -
    Projected Profit - 500,000 500,000 500,000 500,000
    Present Value -6000000 471700 445000 419800 396050
    Year 5 Year 6 Year 7 Year 8 Year 9 Year 10

    - - - - - -
    -8,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000
    0.68058 0.63017 0.58349 0.54027 0.50025 0.46319 NPV
    -5,444,640 630,170 583,490 540,270 500,250 463,190 -16,071,205 NPV
    NPV

    Year 5 Year 6 Year 7 Year 8 Year 9 Year 10

    - - - - - -
    Yes Yes Yes Yes Yes Yes
    0.7473 0.705 0.6651 0.6274 0.5919 0.5584
    Yes Yes Yes Yes Yes Yes Yes NPV

    - - - - - -
    -8,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000
    -5978400 705000 665100 627400 591900 558400 -7,098,050 NPV
    TOTAL -21196100
    CM

    CMR

    Break-even units (number of products)

    Break-even $ (sales revenue)

    Units required to achieve a target profit of $50,000

    Sales Revenue required to achieve a target profit of $50,000


    Yes 1.5

    Yes 1.5

    Yes 3

    Yes 3

    Yes 3

    Yes 3
    TOTAL 15

    You might also like