Purchase Solution

Conch Republic Electronics

Not what you're looking for?

Ask Custom Question

Conch Republic Electronics
Spent $750.00 to develop a prototype (or Model) for a new PDA
Spent an additional $200,000 for marketing study to determine the expected sales.
Can manufacture the new PDA with variable cost for $86.00 each.
Fixed Costs for the operation are estimated at $3 million per year.
Unit Price $250.00 each
Necessary equipment to produce the PDA will cost $15 million, with depreciation for 7 years MACRS schedule.
It is believed that this equipment after 5 years will be worth $3 million.
NWC will be 20% of Sales
Changes in NWC will occur in Year 1, with the first year sales.
There is no initial outlay for NWC.
Conch Republic Corporate Tax Rate is 35% and has a 12% required return.
Estimated Sales Volumes:
NWC 20%
Year Est.Sales of Sales
1 70,000 14,000
2 80,000 16,000
3 100,000 20,000
4 85,000 17,000
5 75,000 15,000

Prepare pro forma financial statement and Project cash flows.
Calculate NPV, IRR, Payback period, PI

Purchase this Solution

Solution Summary

This solution is comprised of a detailed explanation to answer the request of the assignment in excel file.

Solution Preview

Conch Republic Electronics
Spent $750.00 to develop a prototype (or Model) for a new PDA
Spent an additional $200,000 for marketing study to determine the expected sales.
Can manufacture the new PDA with variable cost for $86.00 each.
Fixed Costs for the operation are estimated at $3 million per year.
Unit Price $250.00 each
Necessary equipment to produce the PDA will cost $15 million, with depreciation for 7 years MACRS schedule.
It is believed that this equipment after 5 years will be worth $3 million.
NWC will be 20% of Sales
Changes in NWC will occur in Year 1, with the first year sales.
There is no initial outlay for NWC.
Conch Republic Corporate Tax Rate is 35% and has a 12% required return.
Estimated Sales Volumes:
NWC 20%
Year Est.Sales of Sales
1 70,000 14,000
2 80,000 16,000
3 100,000 20,000
4 85,000 17,000
5 75,000 15,000

Prepare pro forma financial statement and Project cash flows.
Calculate NPV, IRR, Payback period, PI

Year 0 1 2 3 4 5
I. Investment Outlay
1. Develop a prototype -750
2. Marketing study -200,000
3. Equipment -15,000,000
4. Total net ...

Purchase this Solution


Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Introduction to Finance

This quiz test introductory finance topics.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.