I would like an income statement for the laptop and tablet seperately. I would a

Question

I would like an income statement for the laptop and tablet seperately. I would also like the present Worth (PW) and IRR for each. Thanks.

Data Block Laptop Replacement Tablet Proposal Year 0 Year 3 Year 0 Year 3 Investment Depreciable Investment Depreciable Replacement Laptops $1,000 each nurse yes Replacement Tablets $750.00 each nurse Yes Laptop Conversion $5,000 total cost Yes Database Conversion $30,000.00 total cost Yes Nurse Training Nurse Training $500.00 each nurse No Staff Training Staff Training $10,000.00 total cost No Nurse Staffing Year 0 Year 1 Year 2 Year 3 Nurse Staffing Year 0 Year 1 Year 2 Year 3 Nurses 40 43 45 47 Nurses 40 40 40 40 Change in # of nursesNurses 0 3 5 7 Change in # of nursesNurses 0 0 0 0 Visits per week 30 30 30 30 Visits per week 30 32 34 35 Change in Visits per week 0 0 0 Change in Visits per week 2 4 5 Weeks per year 48 48 48 Weeks per year 48 48 48 Addl.Visits per year (calculated) 4,320 7,200 10,080 Addl.Visits per year (calculated) 3,840 7,680 9,600 Nursing Salaries ea. incl. benefits $95,000 $95,000 $95,000 Nursing Salaries ea. incl. benefits $95,000 $95,000 $95,000 Office Staffing Office Staffing Added staff 0 0 0 0 Added staff 1 1 1 Staff Salary incl. benefits Staff Salary incl. benefits $60,000 $60,000 $60,000 $60,000 Revenue Revenue Average revenue per visit $112.00 all years Average revenue per visit $112.00 all years Cost per visit Cost per visit Travel cost $6.50 per visit all years Travel cost $6.50 per visit all years Cloud Processing cost $0.00 per visit all years Cloud Processing cost $3.00 per visit all years Supplies $8.00 per visit all years Supplies $8.00 per visit all years Annual Expenses Annual Expenses Tablet Software Licenses $0.00 annually per nurse all years Tablet Software Licenses $50.00 annually per nurse all years Site Office software $0.00 annually- all all years Site Office software $40,000.00 annually- all all years Site Maintenance contract $45,000.00 annually- all all years Site Maintenance contract $35,000.00 annually- all all years Wireless contract $0.00 Monthly per nurse all years Wireless contract $500.00 Monthly per nurse all years Other Other Present Laptops Book Value $0.00 each Present Laptops Book Value $0.00 each Time horizon 3 Years Time horizon 3 Years Tax Rate 22% Tax Rate 22% MARR 14% MARR 14% MACRS 3 years MACRS 3 years

Explanation / Answer

Particulars WN                                   1                              2                              3 Revenue                     6,45,120                9,67,680             12,90,240 Total                     6,45,121                9,67,682             12,90,243 Less: Expenses Travel cost                         37,440                    56,160                   74,880 Cloud                                  -                               -                              -   Supplies                         46,080                    69,120                   92,160 Annual Salaries                         95,000                    95,000                   95,000 Site Maintenance contract                     1,35,000                1,35,000               1,35,000                     3,13,520                3,55,280               3,97,040 Depreciation                         13,333                    14,333                   15,000 Profit                     3,31,600                6,12,400               8,93,200 Statement showing Revenue Year Basis Units Revenue / Unit Total Cost 1 Normal Visits Visits 5760 112 645120 2 Normal Visits Visits 8640 112 967680 3 Normal Visits Visits 11520 112 1290240 25920 29,03,040.00 Statement showing Costs Year Basis Units Cost / Unit Total Cost 1 Travel cost Visits 5760                              7              37,440 2 Travel cost Visits 8640                              7              56,160 3 Travel cost Visits 11520                              7              74,880 1 Supplies Visits 5760                              8              46,080 2 Supplies Visits 8640                              8              69,120 3 Supplies Visits 11520                              8              92,160 1 - 3 Site Maintenance contract Annual 3                   45,000 135000     5,10,840.00 Depreciation MACRS straightline Depreciation for yr 1 Depreciation for yr 2 Depreciation for yr 3 On Amount 40000 3000 2000 0 1 13333.3333             13,333.33 2 13333.3333 1000             14,333.33 3 13333.3333 1000                    666.67             15,000.00 Statement showing Cash Flows Year Basis Units Cost/Unit Amount DF @ 14% 0 Laptop cost Nurses 40 1000             -40,000 1.0000             -40,000 0 Laptop conversion Total                             -                              -                 -5,000 1.0000               -5,000 1 Laptop cost Additional Nurses 3 1000               -3,000 0.8772               -2,632 2 Laptop cost Additional Nurses 2 1000               -2,000 0.7695               -1,539 3 Laptop cost Additional Nurses 2 1000               -2,000 0.6750               -1,350 1 Revenues           6,45,121 0.5921           3,81,963 2 Revenues           9,67,682 0.5194           5,02,584 3 Revenues        12,90,243 0.4556           5,87,817 1 Cost         -3,13,520 0.3996         -1,25,294 2 Cost         -3,55,280 0.3506         -1,24,547 3 Cost         -3,97,040 0.3075         -1,22,093 NPV         10,49,910

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---