Question

Consider a project to supply 102 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $1,920,000 five years ago; if the land were sold today, it would net you $2,120,000 aftertax. The land can be sold for $2,320,000 ter taxes in five years You will need to install $5.42 million in new manufacturing plant and equipment to actually produce the stamps; this plant and equipment will be depreciated straight-line to zero over the projects five-year life The equipment can be sold for $520,000 at the end of the project. You will also need $620,000 in initial net working capital for the project, and an additional investment of $52,000 in every year thereafter. Your production costs are 0.52 cents per stamp, and you have fixed costs of $1,070,000 per year. If your tax rate is 30 percent and your required return on this project is 10 percent, what bid price should you submit on the contract? (Do not round intermediate calculations and round your final answer to 5 decimal places. (e.g., 32.16161)) Bid price
0 0
Add a comment Improve this question Transcribed image text
Answer #1

File Home InsertPage LayoutFormulas DataReview View DeveloperNitro Pro8 5 EX 2 AutoSum 11.A. A-=-9- Ewrap Text General Copy Format Painter B 1 υ.-B. ク.Δ. 囍Merge & Center. ,00 Conditional Format Cell Insert Delete Format = . % , Sort & Find & Format Painter Clipboard 2 Clear Filter Select Editing Formatting as Table Styles Font Alignment Number Cells 0 Calculation of Minimum BID PRICE Purchase of machine Initial W Total Initial Outflow 5,420,000 620,000 S 6,040.000 B. Annual Cash Flow Outflow Additional Investment in Working Capital -S 52,000 - 52,000 -S 52,000 -S 52,000 -S 52,000 S 749 Add: Fixed Cost after tax per year Less: Tax Benefit on Depreciation Total Cash Outlow PVF @ 10% PV of Cash Flow Outflow 10 749,000S 749,000 749,000 749, 294,0001$ 294,0001$ 294,0001 $ 294,000 294,000 507,000 S 507,000 S 507,000 S 507.000 S 507,000 12 -S 0.7513 0.6209 460,909 -S 419,008 -S 380,917 -S 346,288 -S 314,807 13 0.9091 0.8264 0.6830 15 16 C. Terminal cash Flow 0.6209 of Salvage Value 322879 of Total Fixed Cash Outflow 7639049.8 510000000 0.014979 Total no. of stamps ost per unit to recover Fixed Cost Variable Cost per Stamp 0.5 id Price Per Sta 0.53498 14 4トHI Sheet8 . Sheet, SheetS . Sheeto Sheet7 Ready ! Em 8596

Formula View:File Home Insert Page Layout﹁ Formulas Data Review View Developer Nitro Pro 5 EX Define Name calculate Now | 嚃Trace Dependents ◆Error Checking 水 e-use in Formula , Insert Autosum Recently Financial Logical Text Date & Lookup & Math More - Time- Reterence - & Trig - FunctionsManager ECreate from SelectionRemove Arrows-Evaluate Formula W wwn dow Calculation-Calculate Sheet Used Remove Arrows Evaluate Formula Function Library Defined Names Formula Auditing Calculation Calculation of Minimum BID PRIC A. Initial Outflow 5420000 Purchase of machine nitial Wo Total Initial Outflow -SUM C3:C4) B. Annual Cash Flow Outflow ditional Investment in Working Capital 52000 52000 52000 52000 Add: Fixed Cost after ta ess: Tax Benefit on Depreciation Total Cash Outflow PVF 10% PV of Cash Flow Outflow -10 70000+0.7 -980000 0.3 -SUBTOTAL 109.C9:C1l -11.1-Table 1#Headers -C13+C12 1070000-О.7 -980000 0.3 -SUBTOTAL 109,D9 DI1)-SUBTOTAL (109 19:E1I) -SUBTOTAL (109,F9:F11)-SUBTOTAL (109.G9 G1l = 1.1.1*Table 3-Headers D13 D12 --1070000 0.7 -9800000.3 1070000÷0.7 -980000 0.3 -1070000+0.7 -9800000.3 12 1.1 Table3IT#Headers -E13 E2 -1/1.1 TableSIHeaders1[411 1/1.1 Table3I+Headers F13-F12 13 -G13 G12 15 16 C. Terminal cash Flow ge Value 520000 =11.1-Table 18 PVF 1046, 5th Year -Headers of Total Fixed Cash Outflow --(C5+SUM(C 14:014)-C19) Total no. of stamps Cost per unit to recover Fixed Cost 102000000 5 C21/C22 ariable Cost per Stam Bid Price Per Sta 0.52 =SUM(C23:C24) 26 Sheets . Sheet1 Sheets sheets . Sheet7-2 14 ㅔ ト HI Ready

"If you have any Query, then please put it in the comment box."

Add a comment
Know the answer?
Add Answer to:
Consider a project to supply 102 million postage stamps per year to the U.S. Postal Service...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Consider a project to supply 102 million postage stamps per year to the U.S. Postal Service...

    Consider a project to supply 102 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $1,920,000 five years ago; if the land were sold today, it would net you $2,120,000 aftertax. The land can be sold for $2,320,000 after taxes in five years You will need to install $5.42 million in new manufacturing plant and equipment to actually produce the stamps; this plant and...

  • Consider a project to supply 102 million postage stamps per year to the U.S. Postal Service...

    Consider a project to supply 102 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $1,920,000 five years ago; if the land were sold today, it would net you $2,120,000 aftertax. The land can be sold for $2,320,000 after taxes in five years You will need to install $5.42 million in new manufacturing plant and equipment to actually produce the stamps; this plant and...

  • Consider a project to supply 102 million postage stamps per year to the U.S. Postal Service...

    Consider a project to supply 102 million postage stamps per year to the U.S. Postal Service for the next five years. You have an Idle parcel of land available that cost $1.715,000 five years ago, If the land were sold today. It would net you $1.790,000 aftertax. The land can be sold for $1,750,000 after taxes In five years. You will need to Install $5.45 million in new manufacturing plant and equipment to actually produce the stamps; this plant and...

  • Consider a project to supply 95 million postage stamps per year to the U.S. Postal Service...

    Consider a project to supply 95 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $1,680,000 five years ago, if the land were sold today, it would net you $1,755,000 aftertax. The land can be sold for $1,743,000 after taxes in five years. You will need to install $51 million in new manufacturing plant and equipment to actually produce the stamps, this plant and...

  • Consider a project to supply 95 million postage stamps per year to the U.S. Postal Service...

    Consider a project to supply 95 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $1,680,000 five years ago; if the land were sold today, it would net you $1,755,000 aftertax. The land can be sold for $1,743,000 after taxes in five years. You will need to install $5.1 million in new manufacturing plant and equipment to actually produce the stamps; this plant and...

  • Consider a project to supply 106 million postage stamps per year to the U.S. Postal Service...

    Consider a project to supply 106 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $1,735,000 five years ago; if the land were sold today, it would net you $1,810,000 aftertax. The land can be sold for $1,754,000 after taxes in five years. You will need to install $5.65 million in new manufacturing plant and equipment to actually produce the stamps; this plant and...

  • Consider a project to supply 107 million postage stamps per year to the U.S. Postal Service...

    Consider a project to supply 107 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $1,740,000 five years ago; if the land were sold today, it would net you $1,815,000 aftertax. The land can be sold for $1,755,000 after taxes in five years. You will need to install $5.7 million in new manufacturing plant and equipment to actually produce the stamps; this plant and...

  • Consider a project to supply 97 million postage stamps per year to the U.S. Postal Service...

    Consider a project to supply 97 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $1,690,000 five years ago; if the land were sold today, it would net you $1,765,000 aftertax. The land can be sold for $1,745,000 after taxes in five years. You will need to install $5.2 million in new manufacturing plant and equipment to actually produce the stamps; this plant and...

  • Consider a project to supply 93 million postage stamps per year to the U.S. Postal Service...

    Consider a project to supply 93 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $1,670,000 five years ago; if the land were sold today, it would net you $1,745,000 aftertax. The land can be sold for $1,741,000 after taxes in five years. You will need to install $5 million in new manufacturing plant and equipment to actually produce the stamps; this plant and...

  • Consider a project to supply 90 million postage stamps per year to the U.S. Postal Service...

    Consider a project to supply 90 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $1,655,000 five years ago; if the land were sold today, it would net you $1,730,000 aftertax. The land can be sold for $1,738,000 after taxes in five years. You will need to install $4.85 million in new manufacturing plant and equipment to actually produce the stamps; this plant and...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT