Questions
How do i answer the following question on excel? Consider attending one of the following two...

How do i answer the following question on excel?

Consider attending one of the following two colleges as a full-time student. One is a public university with low tuition, while the other is a prestige university (they are both in the same city, so housing costs should be equal for each). Suppose you qualify for a partial scholarship at the private university. The financial information corresponding to attending each school is as follows.
Public university ​ Private University
Tuition and related expenses four years at: $3500 per year $29,000 per year
Earnings per year for first 5 years ​ $39,000 per year $56,000 per year
Earnings per year for next 10 years ​ $72,000 per year​ $89,000 per year
Earnings per year for next 17 years ​$88,000 per year​ $118,000 per year
Earnings per year for next 12 years ​$74,000 per year​ $90,000 per year​​
Assuming the decision will be made solely on net financial returns grounds, a) Calculate the present value of associated with attending each college using a three percent (3%) interest (i.e. discount) rate, and b) repeat the calculation using an 9.5% interest rate. C) explain whether the difference in interest rates did or did not change the financial decision.

In: Statistics and Probability

The human resources department needs to forecast the number of sexual harassement investigations for the entire company.

 

The human resources department needs to forecast the number of sexual harassement investigations for the entire company. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is the 4 month weighted moving average adjusting for seasonality where the weights, starting with the most recent time period, are 0.4, 0.3, 0.2, 0.1. Again, you must find the seasonality factors for the data. Please round your forecast to the nearest whole number.

Apr 2020: 11 Mar 2020: 10 Feb 2020: 18 Jan 2020: 13 Dec 2019: 11 Nov 2019: 17
Oct 2019: 14 Sep 2019: 15 Aug 2019: 17 Jul 2019: 16 Jun 2019: 15 May 2019: 16
Apr 2019: 15 Mar 2019: 16 Feb 2019: 14 Jan 2019: 11 Dec 2018: 18 Nov 2018: 14
Oct 2018: 12 Sep 2018: 15 Aug 2018: 13 Jul 2018: 17 Jun 2018: 11 May 2018: 17
Apr 2018: 18 Mar 2018: 13

In: Statistics and Probability

Exercise 9-24 Larkspur Company began operations on January 1, 2019, adopting the conventional retail inventory system....

Exercise 9-24

Larkspur Company began operations on January 1, 2019, adopting the conventional retail inventory system. None of the company’s merchandise was marked down in 2019 and, because there was no beginning inventory, its ending inventory for 2019 of $37,700 would have been the same under either the conventional retail system or the LIFO retail system.

On December 31, 2020, the store management considers adopting the LIFO retail system and desires to know how the December 31, 2020, inventory would appear under both systems. All pertinent data regarding purchases, sales, markups, and markdowns are shown below. There has been no change in the price level.

Cost

Retail

Inventory, Jan. 1, 2020

$37,700 $60,500

Markdowns (net)

13,000

Markups (net)

22,000

Purchases (net)

133,500 177,500

Sales (net)

168,600


Determine the cost of the 2020 ending inventory under both (a) the conventional retail method and (b) the LIFO retail method. (Round ratios for computational purposes to 2 decimal place, e.g. 78.72% and final answers to 0 decimal places, e.g. 28,987.)

Ending inventory LIFO retail method

$enter a dollar amount rounded to 0 decimal places

In: Accounting

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in...

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $2 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 3%.

  1. Assume that the company pays no dividends. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar.
    $  

  2. Why is this AFN different from the one when the company pays dividends?
    1. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of additional funds needed.
    2. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of assets needed.
    3. Under this scenario the company would have a higher level of spontaneous liabilities, which would reduce the amount of additional funds needed.
    4. Under this scenario the company would have a lower level of retained earnings, which would increase the amount of additional funds needed.
    5. Under this scenario the company would have a lower level of retained earnings, which would decrease the amount of additional funds needed.

    -Select-IIIIIIIVVItem 2

In: Finance

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in...

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $4 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 3%.

  1. Assume that the company pays no dividends. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar.
    $  

  2. Why is this AFN different from the one when the company pays dividends?
    1. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of assets needed.
    2. Under this scenario the company would have a higher level of spontaneous liabilities, which would reduce the amount of additional funds needed.
    3. Under this scenario the company would have a lower level of retained earnings, which would increase the amount of additional funds needed.
    4. Under this scenario the company would have a lower level of retained earnings, which would decrease the amount of additional funds needed.
    5. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of additional funds needed.

    -Select-IIIIIIIVV

In: Finance

eBook Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million...

eBook

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $2 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 3%.

  1. Assume that the company pays no dividends. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar.
    $  

  2. Why is this AFN different from the one when the company pays dividends?
    1. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of additional funds needed.
    2. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of assets needed.
    3. Under this scenario the company would have a higher level of spontaneous liabilities, which would reduce the amount of additional funds needed.
    4. Under this scenario the company would have a lower level of retained earnings, which would increase the amount of additional funds needed.
    5. Under this scenario the company would have a lower level of retained earnings, which would decrease the amount of additional funds needed.

    -Select-

In: Finance

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in...

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $3 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 7%.

  1. Assume that the company pays no dividends. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar.
    $  

  2. Why is this AFN different from the one when the company pays dividends?
    1. Under this scenario the company would have a lower level of retained earnings, which would increase the amount of additional funds needed.
    2. Under this scenario the company would have a lower level of retained earnings, which would decrease the amount of additional funds needed.
    3. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of additional funds needed.
    4. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of assets needed.
    5. Under this scenario the company would have a higher level of spontaneous liabilities, which would reduce the amount of additional funds needed.

In: Finance

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in...

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $4 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 3%.

  1. Assume that the company pays no dividends. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar.
    $  

  2. Why is this AFN different from the one when the company pays dividends?
    1. Under this scenario the company would have a lower level of retained earnings, which would increase the amount of additional funds needed.
    2. Under this scenario the company would have a lower level of retained earnings, which would decrease the amount of additional funds needed.
    3. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of additional funds needed.
    4. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of assets needed.
    5. Under this scenario the company would have a higher level of spontaneous liabilities, which would reduce the amount of additional funds needed.

choose one

In: Accounting

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in...

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $4 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 5%.

  1. Assume that the company pays no dividends. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar.
    $  

  2. Why is this AFN different from the one when the company pays dividends?
    1. Under this scenario the company would have a lower level of retained earnings, which would decrease the amount of additional funds needed.
    2. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of additional funds needed.
    3. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of assets needed.
    4. Under this scenario the company would have a higher level of spontaneous liabilities, which would reduce the amount of additional funds needed.
    5. Under this scenario the company would have a lower level of retained earnings, which would increase the amount of additional funds needed.

In: Finance

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in...

Carlsbad Corporation's sales are expected to increase from $5 million in 2019 to $6 million in 2020, or by 20%. Its assets totaled $4 million at the end of 2019. Carlsbad is at full capacity, so its assets must grow in proportion to projected sales. At the end of 2019, current liabilities are $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accrued liabilities. Its profit margin is forecasted to be 7%.

  1. Assume that the company pays no dividends. Use the AFN equation to forecast the additional funds Carlsbad will need for the coming year. Write out your answer completely. For example, 5 million should be entered as 5,000,000. Round your answer to the nearest dollar.
    $  

  2. Why is this AFN different from the one when the company pays dividends?
    1. Under this scenario the company would have a higher level of spontaneous liabilities, which would reduce the amount of additional funds needed.
    2. Under this scenario the company would have a lower level of retained earnings, which would increase the amount of additional funds needed.
    3. Under this scenario the company would have a lower level of retained earnings, which would decrease the amount of additional funds needed.
    4. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of additional funds needed.
    5. Under this scenario the company would have a higher level of retained earnings, which would reduce the amount of assets needed.

In: Finance