Section 1
- You are considering bidding on a project to make new cases for mobile phones. The project details include:
- Upfront costs of $350,000 for a new injection-moulding machine.
- 4 year life
- $30,000 in yearly pre-tax operating costs
- Initial investment of $50,000 in working capital
- Your company has a tax rate of 30%
- Your company’s required rate of return is 10%
- At the end of 4 years you can sell the equipment for $30,000
- There is no depreciation consideration for this equipment
a. Complete the following table and calculate the net present value for the project costs.
Year | ||||||
Cash Flows | PV | 0 | 1 | 2 | 3 | 4 |
NPV |
b. What is the projects Equivalent Annual Cost?
c. If the contract requires you to make 25,000 cases, what is the minimum amount you would bid/case?
- BikesAreBetter is now looking at an “Economy Version” of its top selling bicycle. The new version will not include all the same features as its top seller and hence will be offered at a lower price. What are some of the cash flow and market conditions it must consider when evaluating the project? Explain.
Section 2 – Show Your Work
- What is the present value of the following set of cash flows at an 8% discount rate?
Year | 1 | 2 | 3 | 4 |
Cash Flow | $2,000 | -$2,000 | $2,000 | -$2,000 |
- Brad earns 7% per year on a past investment of $100,000. He recently sold his investment for $450,000. How much sooner could Brad have sold the investment if he only wanted $350,000 for it?
- Your credit card company quotes you a rate of 22.5%. Interest is billed monthly. What is the actual rate of interest you are paying?
- You are able to contribute $50 a week to your retirement plan. Assume that you work for 20 years and that you earn 5% per year. How much will you have for retirement?
- Humber College recently purchased some fixed assets that belong in a 20% CCA class. The assets cost $550,000. What is the amount of the depreciation expense in the third year?
- Would you be willing to pay $1000 today in exchange for $10,000 in 20 years? What would you consider in answering yes or no to above?
Section 3
Andrew David is thinking of buying some new equipment for his family business. The equipment costs $300,000 and last for 5 years. It is expected that the new equipment will generate after-tax cash flows of $50,000 in the 1^{st} year and increase by $20,000 each year until it reaches $130,000 in year 5. After the project they will sell the equipment for $50,000, making the total cash flow in year 5 $180,000. Complete the following table. The companies required return is 15%.
Calculate Project’s | Accept or Reject Project? Why? |
Payback? (Benchmark <4years) | |
Discounted Payback? (Benchmark <4years) | |
NPV? | |
Profitability Index? | |
IRR? |
Section 4
a. Based on the following projections complete both the cash flow tables. Use 2 decimal places for all values.
Cash Collections & Disbursements ($’000s) | ||||
Q1 | Q2 | Q3 | Q4 | |
Cash Collections | ||||
Beginning A/R | ||||
Sales | ||||
Cash Collections | ||||
Ending A/R | ||||
Cash Disbursements | ||||
Beginning A/P | ||||
Purchases | ||||
Payment A/P | ||||
Ending A/P | ||||
Total Cash Outflows | ||||
Beginning A/P | ||||
Operating Expenses | ||||
Capital Investments | ||||
Interest & dividends | ||||
Total cash disbursements |
Cash Budget (‘000s) | ||||
Q1 | Q2 | Q3 | Q4 | |
Total Cash Collections | ||||
Total Cash Disbursements | ||||
Net Cash Inflow | ||||
Beginning cash balance | ||||
Ending cash balance | ||||
Minimum cash balance | ||||
Cumulative surplus (deficit) |
b. Based on both tables above, what can you say about this projects viability? What plans might the company have to make?
- Complete the following Short Term Financing Plan. Interest on new short-term borrowing is 2% per quarter. Note: This is a separate question to above.
Short-Term Financing Plan ($‘000s) | ||||
Q1 | Q2 | Q3 | Q4 | |
Beginning cash balance | 100.00 | |||
Net cash inflow | 25.00 | -50.00 | -25.00 | 125.00 |
Ending Cash Balance (before borrowing) | ||||
Interest on short-term borrowing | ||||
New short-term borrowing | ||||
Short-term borrowing repaid | ||||
Ending cash balance (after borrowing) | ||||
Minimum cash balance | 100.00 | 100.00 | 100.00 | 100.00 |
Cumulative surplus (deficit) | ||||
Beginning short-term debt | ||||
Change in short-term debt | ||||
Ending short-term debt |
For solution, please contact at info@myassignmentguru.com or whatsapp/ SMS at +1 (450) 800-2020.