ACCT 5507 Depreciation Consideration for this Equipment: 1259873

Section 1 – (15 Marks)

  1. (12 Marks) You are considering bidding on a project to make new cases for mobile phones.  The project details include:  
    1. Upfront costs of $350,000 for a new injection-moulding machine.
    1. 4 year life
    1. $30,000 in yearly pre-tax operating costs
    1. Initial investment of $50,000 in working capital
    1. Your company has a tax rate of 30%
    1. Your company’s required rate of return is 10%
    1. At the end of 4 years you can sell the equipment for $30,000
    1. There is no depreciation consideration for this equipment
  1. (6 marks) Complete the following table and calculate the net present value for the project costs.
  • (3 marks)What is the projects Equivalent Annual Cost?
Section 1 B 
Equivalent Annual Yieldr(NPV)/(1-(1+R)^-N)
  
R0.1
NPV-284938.8703
N4
  
EAA $       -89,889.89
  • (3 marks) If the contract requires you to make 25,000 cases, what is the minimum amount you would bid/case?
  • (3 Marks) 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 – (20 Marks) – Show Your Work

  1. (3 marks) What is the present value of the following set of cash flows at an 8% discount rate?
Year1234
Cash Flow$2,000-$2,000$2,000-$2,000
  • (3 marks) 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?  
  • (3 marks) 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? 
  • (3 marks) 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? 
  • (3 marks) 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? 
  • (5 marks) 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 – (25 Marks)

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 1st 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 – (25 Marks)

  1. (20 Marks)
    1. (16 Marks) Based on the following projections complete both the cash flow tables.  Use 2 decimal places for all values.
Cash Collections & Disbursements ($’000s)
     
 Q1Q2Q3Q4
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)
     
 Q1Q2Q3Q4
Total Cash Collections    
Total Cash Disbursements    
Net Cash Inflow    
Beginning cash balance    
Ending cash balance    
Minimum cash balance    
Cumulative surplus (deficit)    
  • (4 Marks) Based on both tables above, what can you say about this projects viability?  What plans might the company have to make?
  • (5 Marks) 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)
 Q1Q2Q3Q4
Beginning cash balance100.00   
Net cash inflow25.00-50.00-25.00125.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 balance100.00100.00100.00100.00
Cumulative surplus (deficit)    
Beginning short-term debt    
Change in short-term debt    
Ending short-term debt