Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SmartCamCompany has an opportunity to produce and sell an innovative new smart home camera for homes. To determine whether this would be a profitable and

SmartCamCompany has an opportunity to produce and sell an innovative new smart home camera for homes. To determine whether this would be a profitable and lucrative venture, the company has gathered the following data on probable costs and market potential.

A. New equipment would have to be acquired to produce the smart home camera. The equipment would cost $100,000 and be usable for 12 years. After 12 years, it would have a salvage value equal to 10% of the original cost.

B. An extensive marketing study projectssales in units over the next 12 years as follows.

Year/Years Sales in Units (each year)

1 4,000

2 7,000

3 10,000

4-12 12,000

C. The smart home camera would sell for $45 each; variable costs for production, administration and sales would be $25 per unit.

D. To gain entry into the market, the company would have to advertise heavily in the early years of sales. The advertising program follows.

Year/Years Amount of yearly advertising

1-2 $70,000

3 $50,000

4-12 $40,000

F. Other fixed costs for salaries, insurance, maintenance, and straight-line depreciation on equipment would total $107,500 per year (Straight line depreciation is used).

G. The company's required rate of return is 15%.

Required 1. Compute the net cashflow (cash receipts less yearly cash operating expenses) anticipated from sale of the smart home camera for each year over the next 12 years. 2. Using the data in (1) above and the other data provided in the problem, determine the net present value of the proposed investment. Professional, well organized, easy to follow, Excel Workbook. (formulas are required for all calculations)

Executive Summary in the same Excel Workbook utilizing a textbox, briefly explaining the results of your analysis and a recommendation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Financial Accounting Concepts

Authors: Thomas P. Edmonds, Frances M. Mcnair, Philip R. Olds, Mark Edmonds, Christopher Edmonds

10th Edition

126015940X, 978-1260159400

More Books

Students also viewed these Accounting questions

Question

Be straight in the back without blowing out the chest

Answered: 1 week ago

Question

Wear as little as possible

Answered: 1 week ago

Question

Be relaxed at the hips

Answered: 1 week ago