1
answer
0
watching
78
views
28 Sep 2019
Comprehensive Financial Statement Analysis Part 2 - Q2 (a) - (b) The yard manager wants to purchase a new machine for $600,000 (total cost including delivery, installation and tax). Estimates it will save $110,000 a year for 7 years, with a residual value of $25,000 after 7 years. Required (a): Using NPV analysis, with the company's required rate of return of 7%, should the purchase be approved? (ignore depreciation tax impact) Show NPV calculation in table format by year or using annuity for years 1 - 7. 7% Year Amount Factor NPV Required (b): Should it still be approved if the required rate is raised to 10% due to increasing interest rates?
Comprehensive Financial Statement Analysis Part 2 - Q2 (a) - (b) The yard manager wants to purchase a new machine for $600,000 (total cost including delivery, installation and tax). Estimates it will save $110,000 a year for 7 years, with a residual value of $25,000 after 7 years. Required (a): Using NPV analysis, with the company's required rate of return of 7%, should the purchase be approved? (ignore depreciation tax impact) Show NPV calculation in table format by year or using annuity for years 1 - 7. 7% Year Amount Factor NPV Required (b): Should it still be approved if the required rate is raised to 10% due to increasing interest rates?
Keith LeannonLv2
28 Sep 2019
Related questions
| Directions: Yourassignment this week is to answer the four questions below. Pleasenote that Question #1 has 2 parts, Part A and Part B. Please showyour work for full credit and use the box provided. Please add morerows or columns to the box if needed. | ||||||||
| 1. Gomez Corporation isconsidering two alternative investment proposals with the followingdata: | ||||||||
| Proposal X | Proposal Y | |||||||
| Investment | $850,000 | $468,000 | ||||||
| Useful life | 8 years | 8 years | ||||||
| Estimated annual net | $125,000 | $78,000 | ||||||
| cash inflows for 8 years | ||||||||
| Residual value | $40,000 | $ - | ||||||
| Depreciation method | Straight-line | Straight-line | ||||||
| Required rate of return | 14% | 10% | ||||||
| 1a. How long is the paybackperiod for Proposal X? | ||||||||
| 1b. What is the accountingrate of return for Proposal Y? | ||||||||
| 2. You have beenawarded a scholarship that will pay you $500 per semester at theend of each of the next 8 semesters that you earn a GPA of 3.5 orbetter. You are a very serious student and you anticipate receivingthe scholarship every semester. Using a discount rate of 3% persemester, which of the following is the correct calculation fordetermining the present value of the scholarship? PLEASE STATE WHYYOU CHOSE THE ANSWER THAT YOU DID. | ||||||||
| A) PV = $500 Ã 3% Ã 8 | ||||||||
| B) PV = $500 Ã (Annuity PV factor, i = 3%, n =8) | ||||||||
| C) PV = $500 Ã (Annuity FV factor, i = 6%, n =4) | ||||||||
| D) PV = $1,000 Ã (PV factor, i = 3%, n = 4) | ||||||||
| 3. Maersk MetalStamping is analyzing a special investment project. The projectwill require the purchase of two machines for $30,000 and $8,000(both machines are required). The total residual value at the endof the project is $1,500. The project will generate cash inflows of$11,000 per year over its 8-year life. | ||||||||
| If Maersk requiresa 6% return, what is the net present value (NPV) of this project?(Use present value tables or Excel.) | ||||||||
| 4. HincapieManufacturing is evaluating investing in a new metal stampingmachine costing $30,924. Hincapie estimates that it will realize$12,000 in annual cash inflows for each year of the machine's3-year useful life. | ||||||||
| Approximately,what is the the internal rate of return (IRR) for the machine? (Usepresent value tables or Excel.) | ||||||||
| Puget Concrete is a major west coast supplier of concrete to residential and commercial builders with multiple sites in the Puget Sound area. Concrete is sold (priced) by the cubic yard including costs based on number of cubic tards, delivery costs based on miles driven, and number of truck-hours while at the job site. The company's pricing policy is to price orders for concrete at 25% over full cost per cubic yard for the order. Full cost includes variable costs for concrete, delivery and yard operations plus an allocation for the estimated annual fixed costs of delivery, site operations and administrative costs (see 2017 cost estimates below). | |||||
| Delivery costs include a rate per mile, recognizing that more miles means more gas and maintenance costs, plus a rate per truck-hour (hours on the job) since if kept waiting on a job site the truck must be kept running so the concrete will not harden and the driver must be paid for that time. Site operations is the name for the company's place where the concrete is prepared and loaded in the truck for delivery. | |||||
| The price per cubic foot quoted the customer is based on full cost for the job plus 25% divided by number of cubic yards for the order as follows: | |||||
| Jobs (orders) are priced as follows (using cost plus method): | |||||
| Number of yards x Concrete cost/yard* | * need to compute cost per yard based on cost data below | ||||
| Number of Miles driven x $10 per mile | using the planned miles for that order | ||||
| Number of Truck hours x $50 per hour | using the planned hours for that order | ||||
| Total Job Cost | |||||
| plus Markup (job cost x 25%) | |||||
| Total Price for the order | |||||
| Total price divided by number of cu yds ordered is the quoted price per cu yd (includes delivery) | |||||
| At the start of 2017, the company estimated their costs as follows: | |||||
| Costs included in concrete cost/yard: | |||||
| Direct Material cost = $75 per cubic yard | |||||
| Variable site operations costs = $17 per cubic yard | |||||
| Fixed site operations costs = $300,000 per year | |||||
| Fixed Delivery costs = $500,000 per year | |||||
| Fixed Admin. costs = $2,125,000 per year | |||||
| Costs included in delivery cost: | |||||
| Variable Delivery costs = $10 per mile + $50 per truck hour | |||||
| And estimated 2017 sales volume is as follows: | |||||
| Annual totals (planned): | 2017 amount | ||||
| Total Cubic Yds to be delivered (sold) | 500,000 | ||||
| Total Delivery Miles | 700,000 | ||||
| Total Truck-hours | 25,000 | ||||
| Total number of jobs (orders) | 100 | ||||
| Answer each question below (Q1 - Q5) on the tab for that number. Format answer as needed. | |||||
| Use "Wrap Text" and "Merge cells" to format cells to hold the text answers on the same page (as shown with this sentence). Increase the row height to make the whole line visible. | |||||
| Fill in your name on Tab 1 | |||||
| Comprehensive Analysis Project questions (answer on Q# tab) | |||||
| Q5 | Puget's CFO will be meeting with the bank to apply for a loan, he had the following report parepared to meet the bank's request. Review the trends based on the this data and answer the questions below to prepare for the bank meeting: | ||||
| Report of key ratios for last three years: | 2016 | 2015 | 2014 | ||
| Current ratio | 2.6:1 | 2.4:1 | 2.2:1 | ||
| Current assets / Current liabilities | |||||
| Acid test (quick ratio) | 0.9:1 | 1.0:1 | 1.1:1 | ||
| (Cash + Short-term receivables) / Current liabilities | |||||
| Accounts receivable turnover | 9.2 times | 10.3 times | 11.5 times | ||
| Net credit sales / Accounts receivable | |||||
| Inventory turnover | 8.1 times | 7.8 times | 6.2 times | ||
| Cost of goods sold / Inventory | |||||
| Return on total assets | 14.5% | 13.1% | 11.3% | ||
| (Net income + [Interest expense x (1-Tax rate)]) / Total assets | |||||
| Return on common stockholderâs equity | 17.2% | 15.1% | 12.9% | ||
| Net income / Stockholdersâ equity | |||||
| Priceâearnings ratio | 14.5 | 17.2 | 17.8 | ||
| Market price per share / Earnings per share | |||||
| Earnings per share | $1.52 | $1.51 | $1.54 | ||
| Net income / Number of common shares outstanding | |||||
| Note: There has been no change in number of shares outstanding. | |||||
| Required: Answer each question (a - d) comparing 2016 to prior years and explain which ratio(s) were used and how they are interpreted (results of analysis). | |||||
| a) Is it becoming easier for the company to pay its bills as they come due? | |||||
| b) Are customers paying their credit accounts as well as they were in 2014? | |||||
| c) Is the level of inventory increasing, decreasing, or remaining constant? | |||||
| d) Is the market price of the companyâs stock going up or down compared to 2014? | |||||
| Required: Answer each question comparing 2016 to prior years and explain which ratio(s) were used and how they are interpreted (results of analysis). | ||||
| a) Is it becoming easier for the company to pay its bills as they come due? | ||||
| b) Are customers paying their credit accounts as well as they were earlier? | ||||
| c) Is the level of inventory increasing, decreasing, or remaining constant? | ||||
| d) Is the market price of the companyâs stock going up or down compared to prior level? | ||||
