Last year’s sales of Merisedvir, a therapeutic drug developed by Homeland Pharmaceutics, were $18.2 million. The...

Last year’s sales of Merisedvir, a therapeutic drug developed by Homeland Pharmaceutics, were $18.2 million. The company anticipates an annual sales growth of 6% for Merisedvir. Currently, two other drug companies are developing equivalent drugs to Merisedvir. When the first competitor’s drug enters the marketplace, Homeland Pharmaceutics expects sales to decrease by 25%. When the second competitor’s drug is introduced, sales will decrease by an additional 5 million. Create an Excel spreadsheet that will compute the annual sales for the company up to 2035 allowing the user to enter the year each competitor enters the marketplace.

Expert Solution

SALES OF MERISEDVIR IF OTHER DRUGS HAVENT DEVELOPED TILL 2035

Particulars	2021	2022	2023	2024	2025	2026	2027	2028	2029	2030	2031	2032	2033	2034	2035
Sales	19.29	20.45	21.68	22.98	24.36	25.82	27.37	29.01	30.75	32.59	34.55	36.62	38.82	41.15	43.62

SALES IF FIRST COMPETITOR ENTERED

Particulars	Sales IF NO COMPETITOR ENTERED	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2022	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2023	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2024	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2025	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2026	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2027	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2028	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2029	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2030	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2031	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2032	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2033	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2034	SALES IF FIRST COMPETITOR ENTERED THE MARKET FROM 2035
2021	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29
2022	20.45	20.20	20.45	20.45	20.45	20.45	20.45	20.45	20.45	20.45	20.45	20.45	20.45	20.45	20.45
2023	21.68	21.43	21.43	21.68	21.68	21.68	21.68	21.68	21.68	21.68	21.68	21.68	21.68	21.68	21.68
2024	22.98	22.73	22.73	22.48	22.98	22.98	22.98	22.98	22.98	22.98	22.98	22.98	22.98	22.98	22.98
2025	24.36	24.11	24.11	23.86	23.86	24.36	24.36	24.36	24.36	24.36	24.36	24.36	24.36	24.36	24.36
2026	25.82	25.57	25.57	25.32	25.32	25.07	25.82	25.82	25.82	25.82	25.82	25.82	25.82	25.82	25.82
2027	27.37	27.12	27.12	26.87	26.87	26.62	26.62	27.37	27.37	27.37	27.37	27.37	27.37	27.37	27.37
2028	29.01	28.76	28.76	28.51	28.51	28.26	28.26	28.01	29.01	29.01	29.01	29.01	29.01	29.01	29.01
2029	30.75	30.50	30.50	30.25	30.25	30.00	30.00	29.75	29.75	30.75	30.75	30.75	30.75	30.75	30.75
2030	32.59	32.34	32.34	32.09	32.09	31.84	31.84	31.59	31.59	31.34	32.59	32.59	32.59	32.59	32.59
2031	34.55	34.30	34.30	34.05	34.05	33.80	33.80	33.55	33.55	33.30	33.30	34.55	34.55	34.55	34.55
2032	36.62	36.37	36.37	36.12	36.12	35.87	35.87	35.62	35.62	35.37	35.37	35.12	36.62	36.62	36.62
2033	38.82	38.57	38.57	38.32	38.32	38.07	38.07	37.82	37.82	37.57	37.57	37.32	37.32	38.82	38.82
2034	41.15	40.90	40.90	40.65	40.65	40.40	40.40	40.15	40.15	39.90	39.90	39.65	39.65	39.40	41.15
2035	43.62	43.37	43.37	43.12	43.12	42.87	42.87	42.62	42.62	42.37	42.37	42.12	42.12	41.87	41.87

REDEUCTION OF SALES IF SECOND COPETITOR ENTERS

	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2022	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2023	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2024	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2025	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2026	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2027	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2028	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2029	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2030	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2031	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2032	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2033	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2034	IF SECOND COMPETITOR ENTERED THE MARKET FROM 2035
2021	0	0	0	0	0	0	0	0	0	0	0	0	0	0
2022	5	0	0	0	0	0	0	0	0	0	0	0	0	0
2023	5	5	0	0	0	0	0	0	0	0	0	0	0	0
2024	5	5	5	0	0	0	0	0	0	0	0	0	0	0
2025	5	5	5	5	0	0	0	0	0	0	0	0	0	0
2026	5	5	5	5	5	0	0	0	0	0	0	0	0	0
2027	5	5	5	5	5	5	0	0	0	0	0	0	0	0
2028	5	5	5	5	5	5	5	0	0	0	0	0	0	0
2029	5	5	5	5	5	5	5	5	0	0	0	0	0	0
2030	5	5	5	5	5	5	5	5	5	0	0	0	0	0
2031	5	5	5	5	5	5	5	5	5	5	0	0	0	0
2032	5	5	5	5	5	5	5	5	5	5	5	0	0	0
2033	5	5	5	5	5	5	5	5	5	5	5	5	0	0
2034	5	5	5	5	5	5	5	5	5	5	5	5	5	0
2035	5	5	5	5	5	5	5	5	5	5	5	5	5	5

CONSOLIDATED SALES
(THIS IS TABLE 2 -TABLE 3)

2021	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29	19.29
2022	15.45	20.20	20.45	20.45	20.45	20.45	20.45	20.45	20.45	20.45	20.45	20.45
2023	16.68	16.43	21.43	21.68	21.68	21.68	21.68	21.68	21.68	21.68	21.68	21.68
2024	17.98	17.73	17.73	22.48	22.98	22.98	22.98	22.98	22.98	22.98	22.98	22.98
2025	19.36	19.11	19.11	18.86	23.86	24.36	24.36	24.36	24.36	24.36	24.36	24.36
2026	20.82	20.57	20.57	20.32	20.32	25.07	25.82	25.82	25.82	25.82	25.82	25.82
2027	22.37	22.12	22.12	21.87	21.87	21.62	26.62	27.37	27.37	27.37	27.37	27.37
2028	24.01	23.76	23.76	23.51	23.51	23.26	23.26	28.01	29.01	29.01	29.01	29.01
2029	25.75	25.50	25.50	25.25	25.25	25.00	25.00	24.75	29.75	30.75	30.75	30.75
2030	27.59	27.34	27.34	27.09	27.09	26.84	26.84	26.59	26.59	31.34	32.59	32.59
2031	29.55	29.30	29.30	29.05	29.05	28.80	28.80	28.55	28.55	28.30	33.30	34.55
2032	31.62	31.37	31.37	31.12	31.12	30.87	30.87	30.62	30.62	30.37	30.37	35.12
2033	33.82	33.57	33.57	33.32	33.32	33.07	33.07	32.82	32.82	32.57	32.57	32.32
2034	36.15	35.90	35.90	35.65	35.65	35.40	35.40	35.15	35.15	34.90	34.90	34.65
2035	38.62	38.37	38.37	38.12	38.12	37.87	37.87	37.62	37.62	37.37	37.37	37.12

ekkarill92 answered 1 year ago

Joe Vandal LLC. last year’s sales were $10million. The company spends $3.5 million for purchase of...

Joe Vandal LLC. last year’s sales were $10million. The company spends $3.5 million for purchase of direct materials and $2.5 million for direct labor. Overhead is $3.5 million, and profit is $500,000. Direct labor and direct material vary directly with sales, but overhead does not. The company wants to double its profit. By how much should the firm increase annual sales? By how much should the firm decrease material costs? By how much should the firm decrease labor cost? Please...

Vicon Manufacturing Bhd has reported the following results for last year’s operation: Sales RM30 million Net...

Vicon Manufacturing Bhd has reported the following results for last year’s operation: Sales RM30 million Net operating income RM 5 million Average operating assets RM 15 million Required: (a) Compute Vicon Manufacturing Bhd’s margin. [ 3 marks ] (b) Compute Vicon Manufacturing Bhd’s turnover. [ 3 marks ] (c) Compute the Vicon Manufacturing Bhd’s return on investment. [ 3 marks ] (d) Chief Executive Officer of Vicon Manufacturing Bhd has set a minimum required rate of return on average operating...

Find the ‘best fit’ equation of net income for last year on last year’s sales. Test...

Find the ‘best fit’ equation of net income for last year on last year’s sales. Test the significance of the overall model at 1% level of significance. Company Market value Sales Profits Assets Recent share price P-E Ratio Yield 1 42926 9663 2446.6 11086 38 18 2.67 2 31557 37799 975.0 38870 47 33 3.76 3 19143 7230 1093.5 9590 59 18 2.85 4 9915 4908 737.6 19429 46 16 6.66 5 9094 989 267.7 1203 30 37 0.00 6...

The Robbins Corporation is an oil wholesaler. The firm's sales last year were $1.01 million, with...

The Robbins Corporation is an oil wholesaler. The firm's sales last year were $1.01 million, with the cost of goods sold equal to $620,000. The firm paid interest of $179,000 and its cash operating expenses were $102,000. Also, the firm received $40,000 in dividend income from a firm in which the firm owned 22% of the shares, while paying only $11,000 in dividends to its stockholders. Depreciation expense was $50,000. Use the corporate tax rates shown in the popup window...

Eagle Corporation had $10 Million in Sales last year. Cost of goods sold were $6 Million,...

Eagle Corporation had $10 Million in Sales last year. Cost of goods sold were $6 Million, depreciation expense was $1 Million, interest payment on outstanding debt was $2 Million, and the firm’s tax rate is 35%. What was Eagle Corporation’s Net Income (after tax)? What was Eagle Corporation’s Net Cash Flow? (1 point) What would happen to Net Income and Cash Flow if Depreciation increased by $1 Million? What would happen to Net Income and Cash Flow is the Depreciation...

71. Last year Dania Corporation's sales were $525 million. If sales grow at 9.8% per year,...

71. Last year Dania Corporation's sales were $525 million. If sales grow at 9.8% per year, how large (in millions) will they be 8 years later? a. $1,142.39 b. $1,109.12 c. $1,364.22 d. $1,131.30 e. $842.93 72. How much would $1, growing at 13.7% per year, be worth after 75 years? a. $18,248.03 b. $15,206.70 c. $15,358.76 d. $13,533.96 e. ...

(Financial statement analysis) The annual sales for Salco, Inc. were $ 4.39 million last year. The...

(Financial statement analysis) The annual sales for Salco, Inc. were $ 4.39 million last year. The firm's end-of-year balance sheet was as follows: Salco's income statement for the year was as follows: b. Salco plans to renovate one of its plants and the renovation will require an added investment in plant and equipment of $ 1.03 million. The firm will maintain its present debt ratio of 50 percent when financing the new investment and expects sales to remain constant. The...

(Financial statement analysis) The annual sales for Salco, Inc. were $ 4.47 million last year. The...

(Financial statement analysis) The annual sales for Salco, Inc. were $ 4.47 million last year. The firm's end-of-year balance sheet was as follows: LOADING.... Salco's income statement for the year was as follows: LOADING.... a. Calculate Salco's total asset turnover, operating profit margin, and operating return on assets. b. Salco plans to renovate one of its plants and the renovation will require an added investment in plant and equipment of $ 1.04 million. The firm will maintain its present...

Gross profit margins for the year improved to 20.9% of sales compared to last year’s 18.5%....

Gross profit margins for the year improved to 20.9% of sales compared to last year’s 18.5%. All operations reported improved margins due in large part to improved operating efficiencies as a result of cost reduction measures implemented during the second and third quarters of the fiscal year and increased manufacturing throughout due to higher unit volume sales. Contributing to the improved margins was a favorable materials price variance due to competitive pricing by suppliers as a result of soft demand...

The annual sales for Salco, Inc. were $ 4.55 million last year. The firm's end-of-year balance...

The annual sales for Salco, Inc. were $ 4.55 million last year. The firm's end-of-year balance sheet was as follows: Current assets $499,000 Liabilities $1,001,500 Net fixed assets 1504000 Owners' equity 1001500 Total Assets $2,003,000 Total $2,003,000 LOADING.... Salco's income statement for the year was as follows: Sales $4,550,000 Less: Cost of goods sold (3,506,000) Gross profit $1,044,000 Less: Operating expenses (495,000) Net operating income $549,000 Less: Interest expense (101,000) Earnings before taxes $448,000 Less: Taxes (35%) (156,800) Net...

Question