You will complete a capital budgeting Excel spreadsheet solution ba...

  1. Home
  2. Homework Library
  3. Business
  4. Finance
  5. You will complete a capital budgeting Excel spreadsheet solution ba...

QuestionQuestion

You will complete a capital budgeting Excel spreadsheet solution based on:
Cost of new equipment $14,800,000
Shipping and installation 200,000
Unit sales
Year 1 70,000
Year 2 120,000
Year 3 120,000
Year 4 80,000
Year 5 70,000

Sales price = $300 / unit in years 1-4 and $250/unit in year 5
Variable cost = $140 / unit
Fixed cost = $700,000 per year for all 5 years
Working capital : $200,000 at start of project, recovered at end
Depreciation = straight line over 5 years
Tax rate = 34%
Cost of capital = 15%
You must complete this project using an Excel spreadsheet. Your assignment specifically:
- Lay out the cash flows for years 1-5
- Calculate the project NPV, using the Excel NPV function (write the function on your submitted spreadsheet)
- Calculate the project IRR, using the Excel NPV function (write the function on your submitted spreadsheet)

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.xlsx.

    $15.00
    for this solution

    or FREE if you
    register a new account!

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Finance Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats