Question

In: Finance

Last month your company posted $100,000 with Contracts-R-Us to get approved to bid on contracts via...

Last month your company posted $100,000 with Contracts-R-Us to get approved to bid on contracts via their website. Trump Enterprises is looking for a supplier of red baseball caps, and your boss wants you to bid on the contract. The company requires 112,000 baseball caps per year over the next five years. You estimate that the necessary equipment will cost $790,000, and the equipment will be depreciated straight-line to zero over the project’s life. You believe this equipment can be sold for $62,000 at the end of the project.

You further estimate the fixed costs to be $317,000 per year, and the variable production costs to be $9.50 per hat. You'll need an initial investment in net working capital of $67,000, but this will be recovered at the end of the project. Your tax rate is 35 percent and you require a return of 12 percent on your investment.

What is the lowest bid price (per unit) you should submit (i.e. price where NPV=0)?

Part A: Start by calculating the operating cash flow that, when received as an annuity for 5 years, would set the NPV = 0.  (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
OCF* $   
Part B: Now calculate the bid price.  (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
  Bid price $   

Solutions

Expert Solution

Part A:

Before moving to calculation let us collect available information:

Contract Requirement Years Year * Number of Unit
Customer Requirement 112000 5 560000

Based on the above information and 12% Expected rate of return, We will calculate Unit price (Need to consider tax percnatge while calculating Profit Margin of 12%)

Y0 Y1 Y2 Y3 Y4 Y5
Initial Investment $      790,000.00
Fixed Cost $      317,000.00 $                     317,000.00 $      317,000.00 $      317,000.00 $      317,000.00
Variable Cost $ 1,064,000.00 $                  1,064,000.00 $ 1,064,000.00 $ 1,064,000.00 $ 1,064,000.00
Working Capital $        67,000.00
Scrap Value $        62,000.00
Total Cost $ 7,762,000.00
Less Scrap $        38,017.60
Less WC $        35,180.47
Cost Incurred $ 7,688,801.94
Cost Per Unit $                13.73
Margin Required 12%
Tax Percentage 35%
Adjusted Margin % Required 16.200%
Cost + Margin (Bid Price) $                15.95

Once we identify the selling rate let us find Cash flow with NPV

Y1 Y1 Y1 Y1 Y1
Cash Flows ($ 15.95 *112000) $ 1,786,877.57 $                  1,786,877.57 $ 1,786,877.57 $ 1,786,877.57 $ 1,786,877.57
FC $      317,000.00 $                     317,000.00 $      317,000.00 $      317,000.00 $      317,000.00
VC $ 1,064,000.00 $                  1,064,000.00 $ 1,064,000.00 $ 1,064,000.00 $ 1,064,000.00
Cash Flows Before Tax $      405,877.57 $                     405,877.57 $      405,877.57 $      405,877.57 $      405,877.57
35% Tax $      142,057.15 $                     142,057.15 $      142,057.15 $      142,057.15 $      142,057.15
Cash at year end $      263,820.42 $                     263,820.42 $      263,820.42 $      263,820.42 $      263,820.42
Considering Time value of Money $      235,553.95 $                     210,316.02 $      187,782.16 $      167,662.65 $      149,698.79
Less Scrap $        35,180.47
Less WC $        38,017.60
NPV (Operating Cash Flow) $    1,024,211.64

Kindly let us know if further queries.

Thanks.


Related Solutions

Last month, two employees were terminated for submitting fraudulent timesheets which were approved and paid through...
Last month, two employees were terminated for submitting fraudulent timesheets which were approved and paid through the accounting system. The leadership team expressed concern that this practice could be widespread. As a financial accounting manager at Waterbag Inc., you were assigned to a project to identify solutions to prevent recurrences. Using the terms accounts payable fraud cases or payroll fraud cases, find a recent example or examples of cases involving accounts payable or payroll. Based on your research, what recommendations...
Last month, two employees were terminated for submitting fraudulent timesheets which were approved and paid through...
Last month, two employees were terminated for submitting fraudulent timesheets which were approved and paid through the accounting system. The leadership team expressed concern that this practice could be widespread. As a financial accounting manager at Waterbag Inc., you were assigned to a project to identify solutions to prevent recurrences. Using the terms accounts payable fraud cases or payroll fraud cases, find a recent example or examples of cases involving accounts payable or payroll. Based on your research, what recommendations...
You have invested $100,000 in the US stock market via the S&P 500 Depository Receipts ETF...
You have invested $100,000 in the US stock market via the S&P 500 Depository Receipts ETF (SPY) which tracks the S&P 500 Index. You are going to pull out your money once your investment triples in value (i.e. becomes $300,000). Assume, that the S&P 500 Depository Receipts ETF (SPY) which you have invested in earns a 9% per annum rate of return. How many years is it expected to be until you are going to pull out your money? Round...
In this weeks assignment you will be sharing your favorite recipe with us via a web...
In this weeks assignment you will be sharing your favorite recipe with us via a web page. The recipe is of your choice and does not have to be a culinary creation, it can be anything! Your web page style and aesthetic should compliment your recipe, do some research for design inspiration if you cannot think of anything. Requirements: Use an external CSS & JS file, no internal or inline styles & scripts Please comment your JS to break down...
The price of Japanese Yen "in US dollars" was 0.0089 last month and is 0.0084 today....
The price of Japanese Yen "in US dollars" was 0.0089 last month and is 0.0084 today. Which of the following is TRUE given this information? Select one: a. The Japanese Yen has lost value against the US dollar. b. The US dollar has lost value against the Japanese Yen. c. Turning a US dollar into Yen today would give you approximately 5 more Yen today versus the amount of Yen you would have received last month. d. Today, 1000 Japanese...
Question text The price of British Pounds "in US dollars" was 1.5355 last month and is...
Question text The price of British Pounds "in US dollars" was 1.5355 last month and is 1.5347 today. Which of the following is TRUE given this information? Select one: a. The value of the US dollar has not changed with respect to the British Pound. b. The British Pound has lost value against the US dollar. c. Turning 100 British Pounds into US dollars today would give you approximately one more dollar compared to the amount of you would have...
You need $100,000 to start your own business. Consider the following loan contracts. All your payments...
You need $100,000 to start your own business. Consider the following loan contracts. All your payments are made at the end of each month for 10 years to pay off the loan Bank A: 12% APR with 3 points Bank B: 12.3% APR with 1 point Which bank would you choose? Bank A: Bank B: All work must be shown to get correct Unfortunately that is all the info given
Calculating a Bid Price Your company has been approached to bid on a contract to sell...
Calculating a Bid Price Your company has been approached to bid on a contract to sell 15,000 voice recognition (VR) computer keyboards a year for four years. Due to technological improvements, beyond that time they will be outdated and no sales will be possible. The equipment necessary for the production will cost $3.4 million and will be depreciated on a straight-line basis to a zero salvage value. Production will require an investment in net working capital of $75,000 to be...
Jen & Berry’s sold 100,000 pints of ice cream last month according to the following contribution...
Jen & Berry’s sold 100,000 pints of ice cream last month according to the following contribution format income statement Total Per Unit SALES    $330,000    $3.30 VARIABLE COSTS 200,000 2.00 CONTRIBUTION MARGIN $ 130,000 $ 1.30 FIXED COSTS 50,000 NET INCOME $ 80,000 A competing company, Un-Friendly’s, also sold 100,000 pints of ice cream last month according to the following contribution format income statement: Total Per Unit SALES $255,000 $2.55 VARIABLE COSTS 100,000 1.00 CONTRIBUTION MARGIN $ 155,000 $ 1.55...
You are the CEO of a major US apparel company that contracts work to garment manufacturers...
You are the CEO of a major US apparel company that contracts work to garment manufacturers abroad. Employees of one contractor report 20-hour workdays, pay below the minimum wage, overcrowded living conditions, physically abusive supervisors, and confiscation of their passports so they cannot quit. Local officials say labor laws are adhered to and enforced, though abuses appear widespread. You send inspectors to the offending factory abroad, but they uncover no labor violations. A labor-advocacy group claims that supervisors coached workers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT