Questions
A dynamometer test lab currently has 45 computers with 20 printers. The computers cost $3,500 each...

A dynamometer test lab currently has 45 computers with 20 printers. The computers cost $3,500 each and the printers were $350 each when purchased 2 years ago. The market value of the computers is estimated at $750 each today and the printers $75 each today. It is expected that the current equipment will last another 4 years and have no salvage value at that time. Operating expenses are $350 for each computer and $150 for each printer per year.

A new networked system is being considered that would have 45 terminal with a cost of $2.500 each; 7 printers would be purchased at $1000 each. The life of the new system is 6 years with a salvage value of $500 for the terminals and $400 for the printers at the end of that time. Operating expenses for the networked system are $6,000 per year.

A) What are the sunk costs at this point? (5 points)

B) If the firm desires a 15% IRR, determine the best alternative. (20 points)

Show ALL work.

In: Accounting

Input Data Month 0 1 2 3 4 5 6 7 8 9 10 11 12...

Input Data
Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Revenue $             -   $            -   $            -   $        -   $        -   $         -   $    2,500 $    2,875 $    3,306 $    3,802 $    4,373 $    5,028 $    5,783 $    6,650 $    7,648 $      8,795 $   10,114 $   11,631 $   13,376 $   15,382 $   17,689 $   20,343 $   23,394 $   26,903
Monthly Revenue Growth Rate 0% 0% 0% 0% 0% 0% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15%
Terms of Revenue
     Cash Sales (% of revenue) 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70%
     N30 (% of revenue) 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30%
     N60 (% of revenue) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Cost of Good Sold 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8%
Terms of Cost of Goods Sold
     Cash Sales (% of purchases) 0% 0% 0% 0% 0% 0% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70%
     N30 (% of purchases) 0% 0% 0% 0% 0% 0% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30%
     N60 (% of purchases) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Cash Operating Costs
     Compensation 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
      Rent 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200
     Supplies 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10%
     Other Operating Expences 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15%
     Accounting $100 $100 $100 $100 $100 $100 $100 $115 $132 $152 $175 $201 $231 $266 $306 $352 $405 $465 $535 $615 $708 $814 $936 $1,076
     Advertizing $350 350 350 350 350 350 403 463 532 612 704 810 931 1071 1231 1416 1628 1873 2153 2476 2848 3275 3766 4331
Tax Rate 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Income Statement
Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Revenue $0 $0 $0 $0 $0 $0 $2,500 $2,875 $3,306 $3,802 $4,373 $5,028 $5,783 $6,650 $7,648 $8,795 $10,114 $11,631 $13,376 $15,382 $17,689 $20,343 $23,394 $26,903
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $200 $230 $265 $304 $350 $402 $463 $532 $612 $704 $809 $930 $1,070 $1,231 $1,415 $1,627 $1,872 $2,152
Gross Profit $0 $0 $0 $0 $0 $0 $2,300 $2,645 $3,042 $3,498 $4,023 $4,626 $5,320 $6,118 $7,036 $8,091 $9,305 $10,701 $12,306 $14,151 $16,274 $18,715 $21,523 $24,751
Compensation 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Rent 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200
Supplies 0 0 0 0 0 0 250 288 331 380 437 503 578 665 765 879 1,011 1,163 1,338 1,538 1,769 2,034 2,339 2,690
Other operating Expences 0 0 0 0 0 0 375 431 496 570 656 754 867 998 1,147 1,319 1,517 1,745 2,006 2,307 2,653 3,051 3,509 4,035
Accounting 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100
Advertizing 350 350 350 350 350 350 403 463 532 612 704 810 931 1,071 1,231 1,416 1,628 1,873 2,153 2,476 2,848 3,275 3,766 4,331
Earnings Before Taxes -$650 -$650 -$650 -$650 -$650 -$650 $973 $1,163 $1,383 $1,635 $1,926 $2,259 $2,643 $3,085 $3,593 $4,176 $4,848 $5,620 $6,508 $7,529 $8,704 $10,054 $11,608 $13,394
Taxes $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Income -$650 -$650 -$650 -$650 -$650 -$650 $973 $1,163 $1,383 $1,635 $1,926 $2,259 $2,643 $3,085 $3,593 $4,176 $4,848 $5,620 $6,508 $7,529 $8,704 $10,054 $11,608 $13,394
Cash Flow
Cash Collected from Revenue $0 $0 $0 $0 $0 $0 $1,750 $2,763 $3,177 $3,653 $4,201 $4,832 $5,556 $6,390 $7,348 $8,451 $9,718 $11,176 $12,852 $14,780 $16,997 $19,547 $22,479 $25,850
Cash Payments on COGS $0 $0 $0 $0 $0 $0 $0 $200 $230 $265 $304 $350 $402 $463 $532 $612 $704 $809 $930 $1,070 $1,231 $1,415 $1,627 $1,872
Cash Operating Expenses ETC $650 $650 $650 $650 $650 $650 $1,328 $1,482 $1,659 $1,863 $2,097 $2,367 $2,677 $3,033 $3,443 $3,915 $4,457 $5,080 $5,797 $6,622 $7,570 $8,661 $9,915 $11,357
Taxes $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Cash Flow -$650 -$1,301 -$1,951 -$2,601 -$3,251 -$3,902 -$3,479 -$2,398 -$1,110 $416 $2,216 $4,331 $6,809 $9,703 $3,373 $3,924 $4,558 $5,286 $6,124 $7,088 $8,196 $9,471 $10,936 $12,622
Cash Account Balance $3,000 $2,350 $1,049 -$902 -$3,503 -$6,754 -$10,655 -$14,134 -$16,532 -$17,642 -$17,226 -$15,010 -$10,679 -$3,870 $5,833 $9,206 $13,130 $17,688 $22,974 $29,099 $36,187 $44,383 $53,854 $64,790 $77,412

Compute, if possible, how much revenue would be needed to breakeven in terms of cash flow. Comment on the financial viability of the venture. Would you suggest any changes? If so, what are they? If you do, this becomes your ‘base’ model.

In: Accounting

Input Data Month 0 1 2 3 4 5 6 7 8 9 10 11 12...

Input Data
Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Revenue $             -   $            -   $            -   $        -   $        -   $         -   $    2,500 $    2,875 $    3,306 $    3,802 $    4,373 $    5,028 $    5,783 $    6,650 $    7,648 $      8,795 $   10,114 $   11,631 $   13,376 $   15,382 $   17,689 $   20,343 $   23,394 $   26,903
Monthly Revenue Growth Rate 0% 0% 0% 0% 0% 0% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15%
Terms of Revenue
     Cash Sales (% of revenue) 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70%
     N30 (% of revenue) 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30%
     N60 (% of revenue) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Cost of Good Sold 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8%
Terms of Cost of Goods Sold
     Cash Sales (% of purchases) 0% 0% 0% 0% 0% 0% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70% 70%
     N30 (% of purchases) 0% 0% 0% 0% 0% 0% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30% 30%
     N60 (% of purchases) 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Cash Operating Costs
     Compensation 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
      Rent 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200
     Supplies 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10%
     Other Operating Expences 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15% 15%
     Accounting $100 $100 $100 $100 $100 $100 $100 $115 $132 $152 $175 $201 $231 $266 $306 $352 $405 $465 $535 $615 $708 $814 $936 $1,076
     Advertizing $350 350 350 350 350 350 403 463 532 612 704 810 931 1071 1231 1416 1628 1873 2153 2476 2848 3275 3766 4331
Tax Rate 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
Income Statement
Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Revenue $0 $0 $0 $0 $0 $0 $2,500 $2,875 $3,306 $3,802 $4,373 $5,028 $5,783 $6,650 $7,648 $8,795 $10,114 $11,631 $13,376 $15,382 $17,689 $20,343 $23,394 $26,903
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $200 $230 $265 $304 $350 $402 $463 $532 $612 $704 $809 $930 $1,070 $1,231 $1,415 $1,627 $1,872 $2,152
Gross Profit $0 $0 $0 $0 $0 $0 $2,300 $2,645 $3,042 $3,498 $4,023 $4,626 $5,320 $6,118 $7,036 $8,091 $9,305 $10,701 $12,306 $14,151 $16,274 $18,715 $21,523 $24,751
Compensation 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Rent 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200
Supplies 0 0 0 0 0 0 250 288 331 380 437 503 578 665 765 879 1,011 1,163 1,338 1,538 1,769 2,034 2,339 2,690
Other operating Expences 0 0 0 0 0 0 375 431 496 570 656 754 867 998 1,147 1,319 1,517 1,745 2,006 2,307 2,653 3,051 3,509 4,035
Accounting 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100
Advertizing 350 350 350 350 350 350 403 463 532 612 704 810 931 1,071 1,231 1,416 1,628 1,873 2,153 2,476 2,848 3,275 3,766 4,331
Earnings Before Taxes -$650 -$650 -$650 -$650 -$650 -$650 $973 $1,163 $1,383 $1,635 $1,926 $2,259 $2,643 $3,085 $3,593 $4,176 $4,848 $5,620 $6,508 $7,529 $8,704 $10,054 $11,608 $13,394
Taxes $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Income -$650 -$650 -$650 -$650 -$650 -$650 $973 $1,163 $1,383 $1,635 $1,926 $2,259 $2,643 $3,085 $3,593 $4,176 $4,848 $5,620 $6,508 $7,529 $8,704 $10,054 $11,608 $13,394
Cash Flow
Cash Collected from Revenue $0 $0 $0 $0 $0 $0 $1,750 $2,763 $3,177 $3,653 $4,201 $4,832 $5,556 $6,390 $7,348 $8,451 $9,718 $11,176 $12,852 $14,780 $16,997 $19,547 $22,479 $25,850
Cash Payments on COGS $0 $0 $0 $0 $0 $0 $0 $200 $230 $265 $304 $350 $402 $463 $532 $612 $704 $809 $930 $1,070 $1,231 $1,415 $1,627 $1,872
Cash Operating Expenses ETC $650 $650 $650 $650 $650 $650 $1,328 $1,482 $1,659 $1,863 $2,097 $2,367 $2,677 $3,033 $3,443 $3,915 $4,457 $5,080 $5,797 $6,622 $7,570 $8,661 $9,915 $11,357
Taxes $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Cash Flow -$650 -$1,301 -$1,951 -$2,601 -$3,251 -$3,902 -$3,479 -$2,398 -$1,110 $416 $2,216 $4,331 $6,809 $9,703 $3,373 $3,924 $4,558 $5,286 $6,124 $7,088 $8,196 $9,471 $10,936 $12,622
Cash Account Balance $3,000 $2,350 $1,049 -$902 -$3,503 -$6,754 -$10,655 -$14,134 -$16,532 -$17,642 -$17,226 -$15,010 -$10,679 -$3,870 $5,833 $9,206 $13,130 $17,688 $22,974 $29,099 $36,187 $44,383 $53,854 $64,790 $77,412

If an angel offered funding of $30,000 for 40% of your company, how would you view the angel’s offer?

In: Accounting

Question 7 (7 points) During June, Bravo Magazine sold for cash six advertising spaces for $400...

Question 7 (7 points)

During June, Bravo Magazine sold for cash six advertising spaces for $400 each to be run in the July through December issues. On that date, Bravo properly recognized Unearned Revenue. The adjusting entry to record on July 31 includes:

Question 7 options:

a debit to Cash for $2,000

a debit to Unearned Revenue for $400

a credit to Revenue for $2,000

a credit to Unearned Revenue for $400

Question 8 (7 points)

On January 7, Bravo purchased supplies on account for $1,000, and recorded this purchase to the Supplies account. At the end of January, Bravo had $600 of these supplies still on hand. The proper adjusting journal entry at January 31 would:

Question 8 options:

include a credit to Supplies for $400

include a debit to Supplies Expense for $600

include a debit to Accounts Payable for $400

include a debit to Supplies for $1,000

In: Accounting

According to Money magazine, Maryland had the highest median annual household income of any state in 2018 at $75,847.

You may need to use the appropriate appendix table to answer this question.

According to Money magazine, Maryland had the highest median annual household income of any state in 2018 at $75,847. Assume that annual household income in Maryland follows a normal distribution with a median of $75,847 and standard deviation of $33,800.

(a)

What is the probability that a household in Maryland has an annual income of $90,000 or more? (Round your answer to four decimal places.)

(b)

What is the probability that a household in Maryland has an annual income of $50,000 or less? (Round your answer to four decimal places.)

(c)

What is the probability that a household in Maryland has an annual income between $40,000 and $70,000? (Round your answer to four decimal places.)

(d)

What is the annual income (in $) of a household in the ninety-first percentile of annual household income in Maryland? (Round your answer to the nearest cent.)

In: Statistics and Probability

January of 1999, the German Auto Bild magazine randomly tested different tread patterns across all tire...

January of 1999, the German Auto Bild magazine randomly tested different tread patterns across all tire brands as their journalists toured from the UK to the Bulgarian coast. They discovered on one leg of the tour that out of 100 tires, or 12%, shortcomings were due to defective sidewall wire. On another leg they found 125 tires, 15% of the defects were due to poor vulcanization.

a) Find an appropriate 95% confidence interval. Explain the difference in outcomes. Let poor vulcanization represent sample #1.

b) Use your confidence interval to explain the difference in outcomes. 2

c) An expert at TUV  thought defects due to wire imperfections were more common than poor vulcanization issues. Reexamine the question in part “b” using a hypothesis test to determine if you support this German regulator’s expert opinion?

In: Statistics and Probability

Vaughn Magazine sold 9,480 annual subscriptions on August 1, 2020, for $13 each. Prepare Vaughn’s August...

Vaughn Magazine sold 9,480 annual subscriptions on August 1, 2020, for $13 each. Prepare Vaughn’s August 1, 2020, journal entry and the December 31, 2020, annual adjusting entry, assuming the magazines are published and delivered monthly. (If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Credit account titles are automatically indented when amount is entered. Do not indent manually. Record journal entries in the order presented in the problem.) Date Account Titles and Explanation Debit Credit choose a transaction date enter an account title enter a debit amount enter a credit amount enter an account title enter a debit amount enter a credit amount choose a transaction date enter an account title enter a debit amount enter a credit amount enter an account title enter a debit amount enter a credit amount

In: Accounting

A magazine provided overall customer satisfaction scores for AT&T, Sprint, T-Mobile, and Verizon cell-phone services in...

A magazine provided overall customer satisfaction scores for AT&T, Sprint, T-Mobile, and Verizon cell-phone services in major metropolitan areas throughout the United States. The rating for each service reflects the overall customer satisfaction considering a variety of factors such as cost, connectivity problems, dropped calls, static interference, and customer support. A satisfaction scale from 0 to 100 was used with  indicating 0 completely dissatisfied and 100 indicating completely satisfied. The ratings for the four cell-phone services in 20 metropolitan areas are as shown.

Metropolitan Area AT&T Sprint T-Mobile Verizon
Atlanta 70 63 77 80
Boston 69 61 80 77
Chicago 71 62 76 78
Dallas 75 62 80 79
Denver 71 64 79 78
Detroit 73 62 83 80
Jacksonville 73 61 81 82
Las Vegas 72 65 80 82
Los Angeles 66 62 74 79
Miami 68 66 79 81
Minneapolis 68 63 81 78
Philadelphia 72 63 77 79
Phoenix 68 63 82 82
San Antonio 75 62 81 81
San Diego 69 65 78 80
San Francisco 66 66 79 76
Seattle 68 64 80 78
St. Louis 74 63 80 80
Tampa 73 60 79 80
Washington 72 65 77 77

a. Consider T-Mobile first. What is the median rating (to 1 decimal)?

b. Develop a five-number summary for the T-Mobile service.

Smallest value
First quartile (to 2 decimals)
Median (to 1 decimal)
Third quartile (to 2 decimals)
Largest value

c. Are there outliers for T-Mobile? Explain.

All ratings are between     and   .

- Select your answer -Yes, the data contain outliersNo, the data do not contain outliersItem 9

d. Repeat parts (b) and (c) for the other three cell-phone services.

AT&T Sprint Verizon
Smallest value
First quartile (to 2 decimals)
Median (to 1 decimal)
Third quartile (to 2 decimals)
Largest value

Are there outliers for AT&T? Explain.

Limits for AT&T(to 1 decimal)     and  

- Select your answer -Yes, the data contain outliersNo, the data do not contain outliersItem 27

Are there outliers for Sprint? Explain.

Limits for Sprint(to 2 decimals)     and  

- Select your answer -Yes, the data contain outliersNo, the data do not contain outliersItem 30

Are there outliers for Verizon? Explain.

Limits for Verizon(to 2 decimals)     and  

- Select your answer -Yes, the data contain outliersNo, the data do not contain outliersItem 33

e. Which of the following box plots accurately displays the data set?

#1 #2
#3 #4

- Select your answer -Box plot #1Box plot #2Box plot #3Box plot #4Item 34

Which service did the magazine recommend as being best in terms of overall customer satisfaction?

- Select your answer -AT&TSprintT-MobileVerizonItem 35

Discuss what a comparison of the box plots tells about the four services.

- Select your answer -AT&T’sSprint’sT-Mobile’sVerizon’sItem 36  lowest rating is better than the highest - Select your answer -AT&T and SprintAT&T and VerizonSprint and VerizonT-Mobile and VerizonItem 37  ratings and is better than of the - Select your answer -AT&TSprintT-MobileVerizonItem 38 ratings. - Select your answer -AT&TSprintT-MobileVerizonItem 39  shows the lowest customer satisfaction ratings among the four services.

In: Statistics and Probability

1. Social Circle Publications Inc. is considering two new magazine products. The estimated net cash flows...

1. Social Circle Publications Inc. is considering two new magazine products. The estimated net cash flows from each product are as follows:

Year Sound Cellar Pro Gamer
1 $ 65,000 $ 70,000
2    60,000    55,000
3    25,000    35,000
4    25,000    30,000
5    45,000    30,000
Total $220,000 $220,000

Each product requires an investment of $125,000. A rate of 10% has been selected for the net present value analysis.

Present Value of $1 at Compound Interest
Year 6% 10% 12% 15% 20%
1 0.943 0.909 0.893 0.870 0.833
2 0.890 0.826 0.797 0.756 0.694
3 0.840 0.751 0.712 0.658 0.579
4 0.792 0.683 0.636 0.572 0.482
5 0.747 0.621 0.567 0.497 0.402
6 0.705 0.564 0.507 0.432 0.335
7 0.665 0.513 0.452 0.376 0.279
8 0.627 0.467 0.404 0.327 0.233
9 0.592 0.424 0.361 0.284 0.194
10 0.558 0.386 0.322 0.247 0.162

Required:

1a. Compute the cash payback period for each product.

Cash Payback Period
Sound Cellar
Pro Gamer

1b. Compute the net present value. Use the present value of $1 table above. If required, round to the nearest dollar.

Sound Cellar Pro Gamer
Present value of net cash flow total $ $
Less amount to be invested $ $
Net present value $ $

2.

First United Bank Inc. is evaluating three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows:

Branch Office Expansion Computer System Upgrade ATM Kiosk Expansion
Amount to be invested . . . . . . . . . . . . . . . . . . . . . . . $420,000 $350,000 $520,000
Annual net cash flows:
   Year 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .   200,000   190,000   275,000
   Year 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .   160,000   180,000   250,000
   Year 3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .   160,000   170,000   250,000
Present Value of $1 at Compound Interest
Year 6% 10% 12% 15% 20%
1 0.943 0.909 0.893 0.870 0.833
2 0.890 0.826 0.797 0.756 0.694
3 0.840 0.751 0.712 0.658 0.579
4 0.792 0.683 0.636 0.572 0.482
5 0.747 0.621 0.567 0.497 0.402
6 0.705 0.564 0.507 0.432 0.335
7 0.665 0.513 0.452 0.376 0.279
8 0.627 0.467 0.404 0.327 0.233
9 0.592 0.424 0.361 0.284 0.194
10 0.558 0.386 0.322 0.247 0.162

Required:

2a. Assuming that the desired rate of return is 15%, prepare a net present value analysis for each project. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net present value. If required, round to the nearest dollar.

Branch Office Expansion Computer System Upgrade ATM Kiosk Expansion
Present value of net cash flow total: $ $ $
Less amount to be invested: $ $ $
Net present value: $ $ $

2b. Determine a present value index for each project. If required, round your answers to two decimal places.

Present Value Index
Branch Office Expansion
Computer System Upgrade
ATM Kiosk Expansion

In: Accounting

A magazine provided overall customer satisfaction scores for AT&T, Sprint, T-Mobile, and Verizon cell-phone services in...

A magazine provided overall customer satisfaction scores for AT&T, Sprint, T-Mobile, and Verizon cell-phone services in major metropolitan areas throughout the United States. The rating for each service reflects the overall customer satisfaction considering a variety of factors such as cost, connectivity problems, dropped calls, static interference, and customer support. A satisfaction scale from 0 to 100 was used with 0 indicating completely dissatisfied and 100 indicating completely satisfied. The ratings for the four cell-phone services in 20 metropolitan areas are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.

 
City AT&T Sprint T-Mobile Verizon
Atlanta 69 68 74 80
Boston 68 66 77 77
Chicago 70 67 73 78
Dallas 74 67 77 79
Denver 70 69 76 78
Detroit 72 67 80 80
Jacksonville 72 66 78 82
Las Vegas 71 70 77 82
Los Angeles 65 67 71 79
Miami 67 71 76 81
Minneapolis 67 68 78 78
Philadelphia 71 68 74 79
Phoenix 67 68 79 82
San Antonio 74 67 78 81
San Diego 68 70 75 80
San Francisco 65 71 76 76
Seattle 67 69 77 78
St. Louis 73 68 77 80
Tampa 72 65 76 80
Washington 71 70 74 77

a. Consider T-Mobile first. What is the median rating (to 1 decimal)?

b. Develop a five-number summary for the T-Mobile service.

Smallest value
First quartile (to 2 decimals)
Median (to 1 decimal)
Third quartile (to 2 decimals)
Largest value

c. Are there outliers for T-Mobile?

_________Yes, the data contain outliersNo, the data do not contain outliers

d. Repeat parts (b) and (c) for the other three cell-phone services.

AT&T Sprint Verizon
Smallest value
First quartile (to 2 decimals)
Median (to 1 decimal)
Third quartile (to 2 decimals)
Largest value

Are there outliers for AT&T?

_________Yes, the data contain outliersNo, the data do not contain outliers

Are there outliers for Sprint?

_________Yes, the data contain outliersNo, the data do not contain outliers

Are there outliers for Verizon?

_________Yes, the data contain outliersNo, the data do not contain outliers

e. Which of the following box plots accurately displays the data set?

#1

Rating

#2

Rating

#3

Rating

#4

Rating

_________Box plot #1Box plot #2Box plot #3Box plot #4

Which service did the magazine recommend as being best in terms of overall customer satisfaction?

_________AT&TSprintT-MobileVerizon

In: Math