in excel - estimates savings, operating costs, income tax, present value, mis

Project Description:

the robert's company

the robert's company, which is switching from a batch-oriented system to an interactive-oriented management information system, conducted a study to evaluate the feasibility of making the transition. this project centers currently on the first step of the feasibility study-in particular, the financial aspects of the exploratory survey. in the exploratory survey report to the mis executive steering committee, financial data on five feasible system alternatives were developed. the data below were used in calculating the net savings (losses) before federal income taxes for mis system alternative #1. the company expects a 20 percent return after federal income taxes, discounted back to the present time.
estimated savings-first year, $120,000
estimated savings-second year, $300,000
estimated savings-third, fourth, and fifth years,
add 7 percent to each previous year
estimated one-time costs-first year, $450,000
estimated additional operating costs-first year, $110,000
estimated additional operating costs-second year, $140,000
estimated additional operating costs-third, fourth, and fifth years, add 7
percent to the previous year
federal income tax rate-48 percent
present value of $1 at 20 percent-first year (calculate with excel formula)
present value of $1 at 20 percent-second year, (calculate with excel formula)
present value of $1 at 20 percent-third year, (calculate with excel formula)
present value of $1 at 20 percent-fourth year, (calculate with excel formula)
present value of $1 at 20 percent-fifth year, (calculate with excel formula)
based upon these facts, determine whether or not the company should study the intangible benefits if the present value of net savings at 20 percent for system alternative #1 is negative after considering all tangible benefits. assume five-year savings and costs projections that start after the completion of the feasibility study.
use the template in next page as a guide.
the roberts company
mis alternative #l
estimated net savings on a rental basis over five years years
years from start of system implementation
1 2 3 4 5 5-year tot
----- ------ ------ ------ ------ ---------------
estimated savings
estimated one-time
costs
estimated addition
at operating cost
total costs
net savings (losses
before federal
income taxes)

the roberts company
mis alternative #1
discounted cash flow - 20% return after federal income taxes on
a rental basis over a five-year period
net savings federal income net savings ---------- at 20% ----------
(losses)before tax rate losses)after present pre value
year federal income at a 48% federal inc value of of net savings
taxes rate taxes $1.00 (losses)
---- ----------------------- --------------------- ------------------ ----------- -------------------
1
2
3
4
5
totals
Skills Required:
Project Stats:

Price Type: Negotiable

Completed
Total Proposals: 7
1 Current viewersl
229 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.9
    1134 Jobs 596 Reviews
    $60 in 1 Day
  • 5.0
    148 Jobs 118 Reviews
    $19 in 4 Hours
  • 5.0
    214 Jobs 139 Reviews
    $35 in 1 Day
  • 4.5
    355 Jobs 236 Reviews
    $30 in 1 Day
  • 4.9
    14 Jobs 9 Reviews
    $30 in 4 Hours
  • 4.6
    647 Jobs 468 Reviews
    $20 in 1 Day