I need the following questions answered: Problem 25 (Ch. 8) ofFundamentals of Co

    I need the following questions answered:
    Problem 25 (Ch. 8) ofFundamentals of Corporate Finance
    Problem
    8 (Ch. 21) of Fundamentals of Corporate
    FinanceBoth are attached. Responses need to be entered on the Excel workbook provided with questions answered. Please help!!!!!!!!
    450000
    0
    45000
    8000
    0
    -53000
    -530001
    40000
    16000
    6000
    11250
    20900
    18660.7142857142832
    30000
    12000
    4000
    11250
    17300
    13791.4540816326520.12
    3
    20000
    8000
    2000
    11250
    13700
    9751.38939504372870.4
    4
    10000
    4000
    0
    11250
    10100
    8706.597674146187350910.155436536854000030000
    -61706.59767414618520000100000-4500000000-45000 Page
    0
    0
    0
    0
    0
    0
    01
    0
    0
    0
    0
    0
    02
    0
    0
    0
    0
    0
    03
    0
    0
    0
    0
    0
    04
    0
    0
    0
    0
    0
    00000 Page
    Expenses
    Depreciation
    Tax rate
    Working Capital
    20% Revenue
    40% Revenue
    SL 4 yrs
    Opp Cost of Capital
    DATA
    Immediate Investment
    Revenues Year 1
    Thereafter
    YEAR
    REVENUES
    EXPENSES
    WORKING
    CAPITAL
    DEPRECIATION
    CASH FLOW
    Revenues Year 2
    Revenues Year 3
    Revenues Year 4
    NPV CASH FLOW
    Sum of NPV y1234
    Add NPV Initial investment (J4) and sum NPV Y1-4 (J9)
    Using NPV formula for CF year 1234 and subtract initial investment
    +
    depreciation * tax rate
    Net income * (1-tax rate)
    decrease in working capital from previous year
    CASH FLOW =
    IRR-INSERT IRR FORMULA IN CELL I13
    Additional costs
    Additional Questions
    What effect would an increase of 2% in the Opportunity Cost of Capital have on the cash flow?
    Would you accept this project at higher interest rates?

    Attachments:

                                                                                                                                      Order Now