PVFtrackingsystem.xlsx
Information Systems 310 with Lo at University of Wisconsin - Eau Claire
About this note
By: Anonymous
Textbook:
Essentials of System Analysis and Design (3rd Edition)
Created: 2010-05-22
File Size: 3 page(s)
Views: 1
Textbook:
Essentials of System Analysis and Design (3rd Edition)Created: 2010-05-22
File Size: 3 page(s)
Views: 1
About StudyBlue
STUDYBLUE makes things that make you better at school.
Things like online flashcards with photos and audio.
Things like personalized quizzes and friendly reminders about when (and what) to study next.
Think of it as a digital backpack™: access to all of your study materials online and on your phone.
STUDYBLUE exists to make studying efficient and effective for every student, for free. Join us.
“Simply amazing. The flash cards are smooth, there are many different types of studying tools, and there is a great search engine. I praise you on the awesomeness.”
Dennis
Dennis
Sign up (free) to study this.
Sheet1 Pine Valley Furniture Economic Feasability Analysis Customer Tracking System Project Year 0 1 2 3 4 5 BENEFIT ANALYSIS Benefit Amount 0 50000 60000 70000 80000 90000 null Discount Rate 0.12 Discount Factor 1 0.89285714285714279 0.79719387755102034 0.71178024781341087 0.63551807840483121 0.56742685571859919 PV of Benefit 0 44642.857142857138 47831.63265306122 49824.617346938758 50841.4462723865 51068.417014673927 Cummulative PV of Benefit 0 44642.857142857138 92474.489795918358 142299.1071428571 193140.5534152436 244208.97042991754 COSTS ANALYSIS One-Time Cost -42500 Discount Rate 0.12 Recurring Costs 0 -28500 -28500 -28500 -28500 -28500 Discount Factor 1 0.89285714285714279 0.79719387755102034 0.71178024781341087 0.63551807840483121 0.56742685571859919 PV of Costs -42500 -25446.428571428569 -22720.025510204079 -20285.737062682208 -18112.265234537688 -16171.665387980076 Cummulative PV of Costs -42500 -67946.428571428565 -90666.454081632648 -110952.19114431486 -129064.45637885254 -145236.12176683263 Change sign for PV of costs 42500 67946.428571428565 90666.454081632648 110952.19114431486 129064.45637885254 145236.12176683263 null null null null null null Overall NPV(net present value) 98972.848663084907 ROI(Return on Investment) 0.68146166021962173 BREAKEVEN ANALYSIS Yearly PV cashflow -42500 19196.428571428569 25111.607142857141 29538.880284256549 32729.181037848812 34896.751626693847 Cummalative NPV cashflow -42500 -23303.571428571428 1808.0357142857101 31346.915998542245 64076.09703639106 98972.848663084907 Project breaks-even between years 1 and 2 Breakeven fraction = (15303-9139)/15303= 0.92800000000000016 Actual breakeven point = 1.9280000000000002 years Sheet2 Sheet3
About this note
By: Anonymous
Textbook: Essentials of System Analysis and Design (3rd Edition)
Created: 2010-05-22
File Size: 3 page(s)
Views: 1
Textbook:
Essentials of System Analysis and Design (3rd Edition)Created: 2010-05-22
File Size: 3 page(s)
Views: 1
About StudyBlue
STUDYBLUE makes things that make you better at school.
Things like online flashcards with photos and audio.
Things like personalized quizzes and friendly reminders about when (and what) to study next.
Think of it as a digital backpack™: access to all of your study materials online and on your phone.
STUDYBLUE exists to make studying efficient and effective for every student, for free. Join us.
“Simply amazing. The flash cards are smooth, there are many different types of studying tools, and there is a great search engine. I praise you on the awesomeness.”
Dennis
Dennis