A company is considering an upgrade of production equipment to reduce costs over the next 5 years. The company can invest $80,000 now, 1 year from now, or 2 years from now. Depending on when the investment is made, the savings will vary. The saving estimates are $26,000, $31,000, or $37,000 per year if the investment is made now, 1 year from now, or 2 years from now, respectively. The company will only invest if the ROR is at least 20% per year. Using a future worth analysis, determine if the timing of the investment will affect the return requirement and, if so, when the investment should be made. Set up the spreadsheet functions necessary to perform the analysis and answer the following questions. Upload your spreadsheet in the location provided below.
(a) Investment Timing (Enter Now / Year 1/ Year 2 / Never):
(b) Estimated Future Worth (dollars): $
Answers: 2
Other questions on the subject: Business
Business, 22.06.2019 14:50, keishadawson
The following information is needed to reconcile the cash balance for gourmet catering services. * a deposit of $5,600 is in transit. * outstanding checks total $1,000. * the book balance is $6,400 at february 28, 2019. * the bookkeeper recorded a $1,800 check as $17,200 in payment of the current month's rent. * the bank balance at february 28, 2019 was $17,410. * a deposit of $400 was credited by the bank for $4,000. * a customer's check for $3,300 was returned for nonsufficient funds. * the bank service charge is $90. what was the adjusted book balance?
Answers: 1
Business, 22.06.2019 19:20, natajayd
The following information is from the 2019 records of albert book shop: accounts receivable, december 31, 2019 $ 42 comma 000 (debit) allowance for bad debts, december 31, 2019 prior to adjustment 2 comma 000 (debit) net credit sales for 2019 179 comma 000 accounts written off as uncollectible during 2017 15 comma 000 cash sales during 2019 28 comma 500 bad debts expense is estimated by the method. management estimates that $ 5 comma 300 of accounts receivable will be uncollectible. calculate the amount of bad debts expense for 2019.
Answers: 2
Business, 23.06.2019 00:30, evryday2285
Three years ago, the city of recker committed to build a park and music venue by the river. it was expected to cost $2.5 million and be paid for from an additional meals tax in the community. the residents pushed back. local restaurants suffered as people ate out less or patronized restaurants in neighboring communities. the project has stalled, but the town council kept pushing it on. this spring, a flood devastated the venue. the town council appears to have suffered from bias
Answers: 3
Business, 23.06.2019 02:30, 310000982
On december 1, 2017, bigham corporation pays a dividend of $4.00 on each share of its common stock. vanessa and gena, two unrelated shareholders, each own 5,000 shares of the stock. vanessa has owned her stock for two years while gena purchased her stock on november 3, 2017. how does each shareholder treat the $20,000 dividend from bigham
Answers: 3
Do you know the correct answer?
A company is considering an upgrade of production equipment to reduce costs over the next 5 years. T...
Questions in other subjects:
Computers and Technology, 24.08.2019 22:30
