Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

FIN 571 Walsh College Cost of Equity via Capital Assets Pricing Model Worksheet

FIN 571 Walsh College Cost of Equity via Capital Assets Pricing Model Worksheet

Question Description

I’m working on a accounting question and need a sample draft to help me learn.

TVM with Excel Assignment #2

Life is messy and deciding how to allocate capital resources is complicated. So, unlike the highly simplifiedproblems used in class (and in the online examples, homework, etc.), this is a more robust capital budgetingdecision problem.Acme Manufacturing, Inc. was originally a family owned operation that has been in business for severalgenerations. It has grown steadily and is now listed on the stock exchange with family members still owning asubstantial portion of the shares. Over the years, the company has acquired a reputation for exceptional qualityand has won awards from major customers.

The firm is 55% equity financed; shares currently trade at $37.00 and do not pay a dividend. Debt capital isprovided by a single issue of bonds (20 year, $1,000 par value, $82.50 annual coupon) currently trading at$1,175. The firm’s beta is 1.25. Their traditional hurdle rate has been 12%, though the rate has not beenreviewed in many years. Over the years, shareholders have come to expect a 10% return. Their corporate taxrate is 25%. Treasury securities are yielding 5.25%.

The market rate of return on equities is 9.25%.The Machine Tool Division is considering the purchase of a piece of highly-automated, robotic productionequipment. It would replace older machines and would offer improvements in quality, and some additionalcapacity for expansion. Because of the magnitude of the proposed expenditure, a careful estimate of theprojects costs and benefits is needed.They are currently using several old-style machines that together had cost $700,000. Depreciation of $220,000has already been charged against this total cost; depreciation charges are $80,000 annually. Managementbelieves these machines will need to be replaced after six more years.

They have a current market value of$250,000.The old machines require 12 workers per shift earning $13.50/hr plus 3 maintenance workers paid $14.50/hr.The plant operates day and afternoon shifts five days each week; maintenance workers are assigned to theafternoon shift only. Maintenance expenses have been running at $5,000 annually; the cost of electricity hasbeen $26,600 per year. The production process is not only labor intensive, but also physically demanding.Workplace injuries are not uncommon and lately medical claims have increased.The new machine will have a total cost that includes shipping, installation and testing of $1.5 million. The plantwill also need $350,000 in modifications to accommodate the new machine. These costs will be capitalized anddepreciated over the six-year estimated life of the machine. The new machine would require only two skilledoperators (one per shift) who would earn $20/hr. Maintenance will be outsourced and cost $90,000 per year.The annual cost of electricity is estimated to be $50,000.Certain aspects of the decision are difficult to quantify. Management’s relationship with the union hasn’t alwaysbeen a smooth one and union leadership may not agree to the layoff of the redundant workers. Reassigningthem to positions in other divisions might be easier but there are currently only a handful of suitable openings,some of which are not in the collective bargaining unit.The specs on the new machine indicate that even higher levels of product quality and lower scrap rates arepossible. In light of ever-increasing competition, this might prove to be of enormous competitive advantage. Thenew machine has a maximum capacity 27% higher than the old semi-automated machines which are currentlyoperating at 90% capacity.

Assignment Parts:

a. Calculate the firm’s Weighted Average Cost of Capital.

b. Identify and analyze the relevant cash flows for the two alternatives – buying the new machine vs.continuing to use the old ones.

c. List and describe briefly any areas of uncertainty or concern for this project – beyond the obvious onesdescribed in the narrative. What effect might they have? Bullet points are just fine.

d. Based on your results in parts b & c, explain why you would or would not proceed with the newmachine.

Guidelines: Show all work and briefly label and explain each step. I must be able to follow your work – points off if I haveto struggle with it.

 Do not change the assumptions in the problem or invent information not provided; however, be sure to listany additional assumptions you feel you need to make

. Complete the solution using Excel formulas and functions to make the necessary calculations for partsa and b – do not just type in numbers.

Just as with TVM, Excel has functions for all the project analysistools. For parts c and d, please insert text boxes and type in your responses.

 Upload your Excel (.xls or .xlsx) solution file online through the assignment link– no hard copies. Noother software/file format is acceptable.

 I expect that the work you submit for grading will be yours and yours alone.

Category PointsCalculations shown/explained, well laid out, easy to follow

WACC calculated correctly

Correct identification/calculation of relevant cash flows:

Correct application of TVM / capital project analysis:

Identify the areas of uncertainty: part c

Logical conclusion supported by results: part d

Late penalty or unacceptable software format

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Gold Grades only hire the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Gold Grades are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Gold Grades is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Gold Grades, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.