Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Jack tar cfo of sheetbend

25/12/2020 Client: saad24vbs Deadline: 10 Days

Sheetbend & Halyard Case


Jack Tar, CFO of Sheetbend & Halyard, Inc., opened the company’s confidential envelope. It contained a draft of a competitive bid for a contract to supply duffel canvas to the US Navy. The cover memo from the Sheetbend’s CEO asked Mr. Tar to review the bid before it was submitted.


The bid and its supporting documents had been prepared by Sheetbend’s sales staff. It called for Sheetbend to supply 100,000 yards of duffel canvas per year for five years. The proposed selling price was fixed at $30 per yard.


Mr. Tar was not usually involved in sales, but this bid was unusual in at least two respects. First, if accepted by the navy, the bid would commit Sheetbend to a fixed-price, long-term contract. Second, producing the duffel canvas would require and investment of $1.5 million to purchase machinery to refurbish Sheetbend’s plant in Pleasantboro, Maine.


Mr. Tar set to work and by the end of the week he had collected the following facts and assumptions:


The plant in Pleasantboro had been built in the early 1900s and is now idle. The plant was fully depreciated on Sheetbend’s books, except for the $10,000 purchase cost of the land (in 1947).


Because the land was valuable shorefront property, Mr. Tar thought the land and the idle plant could be sold, immediately or in the near future, for $600,000.


Refurbishing the plant would cost $500,000. This investment would be depreciated for tax purposes on the ten-year MACRS schedule.


The new machinery would cost $1 million. This investment could be depreciated on the five-year MACRS schedule.


The refurbished plant and new machinery would last for many years.; however, the remaining market for duffel canvas was small, and it was not clear that additional orders could be obtained once the navy contract was finished. The machinery was custom-built and could only be used for duffel canvas. Its second-hand value at the end of five years was probably zero.


Table 1-1 shows the sales staff’s forecast and decided that its assumptions were reasonable, except that the forecast used book, not tax, depreciation.


The forecast income statement contained no mention of working capital, but Mr. Tar thought that working capital would average about ten percent of sales.


Armed with this information, Mr. Tar constructed a spreadsheet to calculate the NPV of the duffel canvas project, assuming that Sheetbend’s bid would be accepted by the navy.


He had just finished debugging the spreadsheet when another confidential envelope arrived from Sheetbend’s CEO. It contained a firm offer from a Maine real estate developer to purchase Sheetbend’s Pleasantboro land and plant for $1.5 million in cash.


Should Mr. Tar recommend submitting the bid to the navy at the purposed price of $30 per yard? The discount rate for this project is twelve percent.


Table 1-1


Forecast income statement for the U.S. Navy duffel canvas project (dollar figures in thousands, except price per yard)


Year:


1


2


3


4


5


1. Yards sold


100.00


100.00


100.00


100.00


100.00


2. Price per yard


30.00


30.00


30.00


30.00


30.00


3. Revenue (1 x 2)


3,000.00


3,000.00


3,000.00


3,000.00


3,000.00


4. Cost of goods sold


2,100.00


2,184.00


2,271.00


2,362.21


2,456.70


5. Operating cash flow (3 – 4)


900.00


816.00


728.64


637.79


543.30


6. Depreciation


250.00


250.00


250.00


250.00


250.00


7. Income (5 – 6)


650.00


566.00


478.64


387.79


293.30


8. Tax at 35%


227.50


198.10


167.52


135.72


102.65


9. Net income (7 – 8)


$422.50


$367.90


$311.12


$252.07


$190.65


Notes:


Yards sold and price per yard would be fixed by contract


Cost of goods includes fixed cost of $300,000 per year plus variable costs of $18 per yard. Costs are expected to increase at the inflation rate of four percent per year.


Depreciation: A $1 million investment in machinery is depreciated straight-line over five years ($200,000 per year). The $500,000 cost of refurbishing the Pleasantboro plant is depreciated straight-line over ten years ($50,000 per year).


Please answer the following questions regarding the case study. Type your answers in the section of the course called “Case Study Two Questions.


Project the cash flows for the navy duffel canvas project for years 0 through 5.


Be sure to take into account the three main parts of a project valuation: initial costs, annual cash flows, and terminal value. As you do so, make the following assumptions (in addition to those already mentioned in the case):


The forecasts in Table 1-1 are accurate, except that depreciation should be calculated according to the MACRS schedules.


The $1.5 million offer for the land and plant represents the property’s true current market value (i.e., what it could be sold for) and the best estimate of its market value in 5 years.


For initial costs, remember to include cash flows for the cost of the land, plant, and machinery. The opportunity cost of the land should be included as part of your initial costs. (Note that if S&H opted to sell the land, there would be tax consequences associated with the sale.) Also remember to account for investment in working capital.


For terminal value, remember to include cash flows for selling or writing off the land, plant, and machinery at the conclusion of the project. (Don’t forget the tax consequences.) Also remember to account for the freeing up of working capital at the end of the project.


Note: Although you could do these projections with pencil, paper, and calculator, you should do this on an Excel spreadsheet. Attach the spreadsheet with your projections to your report.


What is the net present value of the navy duffel canvas project? What is the IRR of the project? Based on the assumptions that have been made, should S&H accept the project?


Perform some sensitivity analysis on your projections. Which assumptions concern you the most? Are there any reasonable changes in assumptions that would make you change your mind about whether or not to accept the project?




1 Project the cash flows for the navy duffel canvas project for years 0 through 5.




Be sure to take into account the three main parts of a project valuation: initial costs, annual cash flows, and terminal value. As you do so, make the following assumptions (in addition to those already mentioned in the case):


The forecasts in Table 8-6 are accurate, except that depreciation should be calculated according to the MACRS schedules.


The $1.5 million offer for the land and plant represents the property’s true current market value (i.e., what it could be sold for) and the best estimate of its market value in 5 years.


For initial costs, remember to include cash flows for the cost of the land, plant, and machinery. The opportunity cost of the land should be included as part of your initial costs. (Note that if S&H opted to sell the land, there would be tax consequences associated with the sale.) Also remember to account for investment in working capital.


For terminal value, remember to include cash flows for selling or writing off the land, plant, and machinery at the conclusion of the project. (Don’t forget the tax consequences.) Also remember to account for the freeing up of working capital at the end of the project.




Note: Although you could do these projections with pencil, paper, and calculator, you should do this on an Excel spreadsheet. Attach the spreadsheet with your projections to your report.




2. What is the net present value of the navy duffel canvas project? What is the IRR of the project? Based on the assumptions that have been made, should S&H accept the project?




3. Perform some sensitivity analysis on your projections. Which assumptions concern you the most? Are there any reasonable changes in assumptions that would make you change your mind about whether or not to accept the project?



Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Writer Writer Name Offer Chat

Writers are writing their proposals. Just wait here to get the offers for your project...

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Too big to fail movie download - Turner's budget furniture moultrie ga - Which of the following elements of the marketing communication mix - Week 6 power pt. policy position - Refer to the lincolnville school district bus data - Performance improvement plan examples - Ap statistics chapter 3 displaying and describing categorical data - Benchmark - Professional Capstone and Practicum Reflective Journal (TOPIC Fall prevention strategies in hospitals.) - Difference between assimilation and inclusion - Minitab anova multiple factors - Please see attached - Need in 24 hours - Post reference for general ledger - Inspector goole final speech analysis - Catholic education office townsville - Excel module 6 sam project 1 - Destination wedding and honeymoon specialist association - Dyson swot analysis - Discussion - Social and cultural perspectives and biases - 0737179697 MAMA SHANANI ABORTION CLINIC IN ELIM - How to create an eportfolio using microsoft word - Genesis summary chapter 1 - Counter narrative essay examples - Create a yahoo email account free - Tiffany and co competitors - Finance 370 - BBC Documentary "Billion Dollar Day" - Career Exploration Paper - Fema is 120 c test answers - Bachelor of midwifery rmit - Ratios and financial planning at east coast yachts solution - Essentials of business communication 11th edition pdf free download - Butterweed tall weeds with yellow flowers - I want a wife judy brady purpose - Suspended ceiling grid screwfix - Olds trumpet serial numbers - N4455 financial management case study - Ocr nationals ict level 2 - Appeals process - Deutsche bank leipzig 04024 - Public Health outbreak and disaster management - Medisys case study - Interactive cross sections of 3d shapes - Hfma's introduction to hospital accounting pdf - IM Response - Role development for the nurse practitioner 2015 - Cadbury schweppes plc annual report - Highest electron affinity is shown by - GHF A.2 - Ethica and Legal Aspects of Nursing Practice DQ 6 Maydenis Molitet - A cross flow heat exchanger used in a cardiopulmonary - The Evolution of armed conflicts - Review a Documentary - Nhs fire safety e learning answers - Excel simulation add in - Which of the following statements is true regarding gainsharing - How did davy crockett actually die - Berlioz symphonie fantastique movement 5 - Commanding heights youtube - Srs restraint system malfunction service required - Data center grounding best practices - Biology in motion atp - Democratic party vs republican party essay - 3 nephi 5 13 - Order 2585033: Staff Hiring Process - Cat6 ethernet color code - Why did the texas constitution establish a plural executive - Clouddeakin - Daikin error code u2 - Supermarket/Grocery Industry Economics Assignment - Education and School Law Order - RTI, MTSS, and Special Education Identification Processes - Writing Assignment Instructions - Revaluation surplus in balance sheet - Strategic Analysis - Struggling Company - A beautiful mind video questions answers - Floraspring reviews - Discussion - Combining like terms and distributive property worksheet - Paper due tomorrow - In media res definition - Laaperi v sears - Chapter 4 using source documents answers - Neis payment rate 2020 - Middleton cheney primary school - Holden outerwear promotes innovation at the individual employee level by - In jina puja (jina worship) the jina does not hear or intercede, but - Attar Shop - Disadvantages of automating a manual accounting system - Ashbeck water eden valley - Literary periods in the philippines - Resistance in a wire simulation answers - Oceania university of medicine - How many earths will fit inside jupiter - Discussion Topic Ch 5 - Looking glass self worksheet - Discussion 2 - Activity based costing and management ppt - Project question related to a Hotel created were environmental factors are being considered - Cambridge latin course book 1 stage 6 felix translation - Subway footlong sub of the month