Prepare net advantage to leasing analysis of the investment

Assignment Help Other Subject
Reference no: EM132193506

Assignment: Case Study - Canada Hardware

It is January 1st, 2018. You are a senior analyst at Canada Hardware Inc. (CHI), one of the top hardware, sports, and apparel providers in Canada with hundreds of stores across Canada. The CEO of Canada Hardware, Tony Stark, has reached out to you to look at two options regarding an investment, building on your analysis from Assignment 1 and Assignment 2.

Purpose

Under this case approach, you will demonstrate your ability to undertake a detailed analysis to evaluate the buy versus lease options for an investment proposal, on a qualitative and quantitative basis. You will also be required to calculate the weighted average cost of capital (WACC). A supplementary scenario analysis of leasing options is required.

How to Proceed

1. Create a title page with your purchase versus lease report name and author identification.

2. Explain the advantages and disadvantages of leasing, including the possible reasons, right or wrong, that would make a company lease an asset (from the lessor and lessee perspective).

3. Calculate the weighted average cost of capital (WACC) to use in your net advantage to leasing (NAL) analysis, rounding to the nearest one tenth of a percent.

4. Prepare your Net Advantage to Leasing analysis of the investment using the WACC as the discount rate. In addition, determine the impacts of the sensitivity analysis in the case, including

a. changes in payments from beginning of period to end;

b. changes in salvage value;

c. security deposit; and

d. the break-even lease payment.

5. Explain and evaluate if the investment should be purchased or leased, depending on the different scenarios analyzed.

6. Determine the classification of the lease option being considered, and indicate what the effect would be on the statement of financial position.

Format for Submission

Your report narratives may be done in Word or Excel, but calculations and tables of values must be prepared in Excel with the amounts derived from actual formulas that use your variables, rounded to four (4) decimals or lower.

The Excel tab worksheet must be print and presentation ready, formatted to print in 2 to 3 pages without page fragmentation of equations or tables between pages.

It is permissible to break your report down using the questions listed above as headings.

Attachment:- Assignment.rar

Verified Expert

This assignment deals with financial planning and calculation of Accounts and thereby choosing the option between renting and leasing. For the closure of this assignment it is necessary to have an expert understanding on capital and discounted capita

Reference no: EM132193506

Questions Cloud

How do you feel about tests in general : How do you feel about tests in general? Are you able to see tests as an opportunity to create your mastery of a subject? Why or why not?
Consequently it often becomes major target of cost reduction : The supply chain is often one of the greatest sources of cost for companies and consequently it often becomes a major target of cost reduction.
Analyze some problems that have affected critical thinking : How have you used critical thinking to improve the quality of your decisions and your strategies for problem solving? Analyze some problems that have affected.
How will you measure the effectiveness of your plan : Do you believe that there should be a limitation on the violent video games that children are permitted to play?
Prepare net advantage to leasing analysis of the investment : FINC 0300 Financial Management - Calculate the weighted average cost of capital (WACC) to use in your net advantage to leasing (NAL) analysis, rounding
Summarize the definition of a gang used by us department : Summarize the definition of a gang used by the U.S. Department of Justice, and then invent a fictional character and explain.
Explain the different types of coatings : Aluminum is widely used in a plenty of industrial applications such as constructions, electrical engineering, transport and especially in aircraft industry.
Some methods it has used to reduce supply chain costs : Discuss in detail some methods it has used to reduce supply chain costs and what results were achieved;
How does text relate to a specific literary movement : Comparison ex :"While the robot in the original Lost in Space TV show was a benign sidekick who always had Will Robinson's back, the reboot version in 2018.

Reviews

len2193506

12/14/2018 1:02:35 AM

Q5 Evaluation of Leasing Options Marks Student Recommendation for original option - lease or buy 2 Recommendation for scenarios: Change in payments 2 Changes in salvage value 2 Security deposit impact 2 Q6 Lease Classifcation Marks Student Determines correct leasing classification 4 Discusses impact on financial statements 4 Total 100 0

len2193506

12/14/2018 1:02:20 AM

Q4 Financial Forecast Marks Initial Analysis WACC utilized as discount rate 2 Appropriate year term applied 2 Correct use of initial investment 2 After-tax leasing payments calculated 2 Present value of after-tax leasing payments 2 Tax Shield calculation 6 Present value of Salvage value 2 Lease payments at beginning of period 2 Scenario Analysis A. Change in payments from beginning to end 4 B. Changes in Salvage Value 4 C. Impact of Security Deposit with end payments 4 D. Breakeven lease payment 4

len2193506

12/14/2018 1:02:11 AM

Q3 WACC Calculation Marks Weighted Cost of Equity ROE calculation 2 Retention calculation 2 Growth Calculation 2 Dividend/Stock calculation 2 Calculation of $ amount of Common Equity 2 Calculation of weight in capital of Common Equity 2 Weighted Cost of Debt After-tax cost of debt 2 Calculation of weight in capital of Debt 2 Weighted Cost of Preferred Equity Cost of Preferred Stock 2 Calculation of weight in capital of Preferred Stock 2

len2193506

12/14/2018 1:02:04 AM

Grading You will be assessed in accordance with the following rubric: Q1 Title Page, Readability, Format, Spelling and Grammar Marks Student Title Page, Readability, Format, Spelling & Grammar 12 Q2 Qualitative Discussion of Leasing vs. Purchasing Marks Student Advantages vs. Disadvantages 4 Reasons for Lessor to lease (at least three) 4 Reasons for Lessee to lease (at least three) 4

len2193506

12/14/2018 1:01:53 AM

Format for Submission Your report narratives may be done in Word or Excel, but calculations and tables of values must be prepared in Excel with the amounts derived from actual formulas that use your variables, rounded to four (4) decimals or lower. The Excel tab worksheet must be print and presentation ready, formatted to print in 2 to 3 pages without page fragmentation of equations or tables between pages. It is permissible to break your report down using the questions listed above as headings. Submit your report file(s) into the Assignment 3: Case Study dropbox on UM Learn. Your assignment must be submitted by the deadline date found in the course schedule provided in the Course Outline.

Write a Review

Other Subject Questions & Answers

  What was it like being a new employee

Describe your experience at an organization that didn't have a good on boarding process. What was it like being a new employee at that organization? Did you feel connected

  Explain the use of sign systems

List several behaviors a teacher should avoid during student conversations. Explain the use of sign systems.

  Is there a relationship between ei and leadership

Is there a relationship between EI and leadership, between EI and motivation? How would you define those relationships?

  Write a report based upon the case study

BUSN20017 Effective Business Communication - Written Report and Oral Presentation - write a report based upon the following case study and then present

  Elements of communication accommodation theory

Describe the elements of Communication Accommodation Theory told in about detail wording Use examples and make it clear.

  Theoretical concepts

What theoretical concepts are attributed to B. F. Skinner? Which one of these concepts had the greatest effect on the field of psychology? Why?

  Contributes to the formation of collective behavior

According to Turner & Killian, the three basic features of collective behavior that demands explanations are “extra-institutionalism,” “from feelings to action,” and “forming and sustaining collectivities.” Discuss how each feature relates or contrib..

  Describe the communicable disease

Describe the determinants of health and explain how those factors contribute to the development of this disease - Describe the communicable disease

  How you will go about getting the job

Have you started researching about how to apply for adatabase manager job? How you will go about getting the job.

  Problems based on study on economics

What would be an example of consumption good?

  Instead of individuals contributing money to alleviate world

According to Singer's article, One might respond to Singer’s proposals by claiming that instead of individuals contributing money to alleviate world poverty, governments should be responsible for handling such efforts. Why doesn’t Singer think that t..

  Describe the product or service and its use

Describe the product or service and its use

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd