Given Acquisition Costs for each segment, is it profitable for Republic Wireless to acquire new customers...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Given Acquisition Costs for each segment, is it profitable for Republic Wireless to acquire new customers for each segment? Briefly explain why or why not for each segment. Note: for this question, compare the Acquisition Costs to the Cumulative Net Margin (Discounted) for each segment at N+10. Customer base valuation In this section, we value the database in monetary terms. Based on which segment customers belong to, they may generate revenues (gross margin) and costs. These figures will be cumulated, and increasingly discounted over time. At one point, discounting of future revenues and costs will be so high that they will become irrelevant for today's valuation, hence ensuring that the customer base valuation will converge to a non-infinity value (even if the customer base keeps growing). Based on predicted customer base evolution and selected discount rate, the customer base is currently valued at $550,281,289 Customer base valuation Gross margin Next-period cost Acquisition cost Net margin Discount Factor Discounted net margin Discounted net margin (cumulated) N+1 $252,032,000 $59,750,000 $4,760,000 $187,522,000 100.0% $187,522,000 $187,522,000 N+2 $186,497,350 $61,215,000 $5,700,000 $119,582,350 90.9% $108,711,227 $296,233,227 N+3 $141.798.734 $45,213,100 $6,580,000 $90,005,634 82.6% $74,384,821 $370,618,048 N +4 $111,335,431 $34,271,453 $7,300,000 $69,763,978 75.1% $52,414,709 $423,032,758 N+5 $88,348,844 $26,803,048 $5,980,000 $55,565,796 68.3% $37,952,186 $460,984,944 N+6 $70,250.383 $21,166,731 $4,800,000 $44,283,652 62.1% $27,496,664 $488,481,608 N+7 $54,629,706 $16,775,430 $2,920,000 $34,934,276 56.4% $19,719,488 $508,201,096 N+8 $41,840.316 $13,013,059 $1,720,000 $27,107,257 51.3% $13,910,309 $522,111,405 N +9 $30,611.974 $9,936,634 $420,000 $20,255,340 46.7% $9,449,266 $531,560,671 N + 10 $22.158,236 $7,261,097 $0 $14,897,139 42.4% $6,317,841 $537,878,512 Infinity $0 $0 $0 $0 0.0% $0 $550,281,289 Given Acquisition Costs for each segment, is it profitable for Republic Wireless to acquire new customers for each segment? Briefly explain why or why not for each segment. Note: for this question, compare the Acquisition Costs to the Cumulative Net Margin (Discounted) for each segment at N+10. Customer base valuation In this section, we value the database in monetary terms. Based on which segment customers belong to, they may generate revenues (gross margin) and costs. These figures will be cumulated, and increasingly discounted over time. At one point, discounting of future revenues and costs will be so high that they will become irrelevant for today's valuation, hence ensuring that the customer base valuation will converge to a non-infinity value (even if the customer base keeps growing). Based on predicted customer base evolution and selected discount rate, the customer base is currently valued at $550,281,289 Customer base valuation Gross margin Next-period cost Acquisition cost Net margin Discount Factor Discounted net margin Discounted net margin (cumulated) N+1 $252,032,000 $59,750,000 $4,760,000 $187,522,000 100.0% $187,522,000 $187,522,000 N+2 $186,497,350 $61,215,000 $5,700,000 $119,582,350 90.9% $108,711,227 $296,233,227 N+3 $141.798.734 $45,213,100 $6,580,000 $90,005,634 82.6% $74,384,821 $370,618,048 N +4 $111,335,431 $34,271,453 $7,300,000 $69,763,978 75.1% $52,414,709 $423,032,758 N+5 $88,348,844 $26,803,048 $5,980,000 $55,565,796 68.3% $37,952,186 $460,984,944 N+6 $70,250.383 $21,166,731 $4,800,000 $44,283,652 62.1% $27,496,664 $488,481,608 N+7 $54,629,706 $16,775,430 $2,920,000 $34,934,276 56.4% $19,719,488 $508,201,096 N+8 $41,840.316 $13,013,059 $1,720,000 $27,107,257 51.3% $13,910,309 $522,111,405 N +9 $30,611.974 $9,936,634 $420,000 $20,255,340 46.7% $9,449,266 $531,560,671 N + 10 $22.158,236 $7,261,097 $0 $14,897,139 42.4% $6,317,841 $537,878,512 Infinity $0 $0 $0 $0 0.0% $0 $550,281,289
Expert Answer:
Answer rating: 100% (QA)
1 Based on the given information it is not profitable for Republic Wireless to acquire new customers for any of the segments The reasons for this vary ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Explain why less profitable customers may become more profitable if a supplier switches to activity-based pricing.
-
section 4 b Why is BYOD security so difficult today section 6 a Give the books definition of network Section 6 b What is a networked application Section 6 e What is a host Section 6 f Is your laptop...
-
This database will soon become useless if it is not kept up to date. List procedures that Dean needs to create and follow to keep his database current.
-
The company of choice is APPLE INC (AAPL). Brief description of the company (one paragraph, briefly summarizing the companys business) Company history (origin, major developments, etc.) Organization...
-
TRUE-FALSE QUESTIONS 1. If the auditor observes that the company reports consistent profits over several years while cash flows are decreasing, then the auditor should assess heightened risk of fraud...
-
The following are various management assertions (a through m) related to sales and accounts receivable. Management Assertion a. All sales transactions have been recorded. b. Receivables are...
-
Ernie Lobb, the cost accountant for Superior Mower Company, recently in- stalled activity-based costing at its St. Louis lawn tractor (riding mower) plant where three models-the 8-horsepower Blade...
-
Passion Company is trying to decide whether or not to acquire Desiree Inc. The following balance sheet for Desiree Inc. provides information about book values. Estimated market values are also...
-
As of December 31, 2021, a firm's net income was $92,000 and its net cash flow from operating activities was $101,600. Over the course of 2021, the firm's accounts receivable balance increased by...
-
Frank Thompson operates a small business that manufactures oversized backyard games. He runs the business as a sole proprietorship. The company uses a job order cost system using a first-in,...
-
Scenario 2 (25pts): The Fore Corporation is an integrated food processing company that has operations in over two dozen countries. Fore's corporate headquarters is in Chicago, and the company's...
-
Suppose instead of using a plantwide predetermined overhead rate, the company had used departmental predetermined overhead rates based on direct labor cost. Under these conditions: Compute the...
-
The Tarboro Corporation data for the current year and prior year is as follows: Account Current year Prior year Current assets $75,600 $60,000 Account receivable $59,400 $44,000 Merchandise inventory...
-
How is the NPV, Total EV, Value of Debt, Equity Value, Initial Equity Investment and Net Equity Value calculated
-
use any method by your choice, mention your choice CoursHeroTranscribedText P11-2 San Francisco Company manufacturers a product in two departments: A and B. Owing to rigid quality of control...
-
a) In your capacity as financial adviser, you are asked to consider the performance of the Xenon and Zerad stocks in UK. The risk-free rate is 6% and the average return of the FTSE 100 is 14%. The...
-
Sheridan Industries, Inc. issued $13,800,000 of 8% debentures on May 1, 2024 and received cash totaling $12,244,227. The bonds pay interest semiannually on May 1 and November 1. The maturity date on...
-
Suppose that you are part of a virtual team and must persuade other team members on an important matter (such as switching suppliers or altering the project deadline). Assuming that you cannot visit...
-
What does a high net wells to gross wells ratio indicate?
-
What is the value added ratio? What does a high (low) value added ratio indicate?
-
What does a low average reserves per well ratio indicate?
Study smarter with the SolutionInn App