Question

In: Computer Science

The given table contains values of Total Benefits and Total Costs for a period of five years. Calculate all other values and fill the table. Use the provided excel file.

The given table contains values of Total Benefits and Total Costs for a period of five years. Calculate all other values and fill the table. Use the provided excel file. 

1. The given table contains values of Total Benefits and Total Costs for a period of five years. Calculate all other values a


Solutions

Expert Solution

Year 1 2 3 4 5 Total
Total Benefits 52587 84364 96870 103574 112851 450246
PV of Benefits ₹ 50,564.42 ₹ 77,999.26 ₹ 86,117.08 ₹ 88,535.49 ₹ 92,755.30
PV of All Benefits ₹ 3,70,069.39
Total Costs 148502 48084 39870 35584 33582 305622
PV of Costs ₹ 1,42,790.38 ₹ 44,456.36 ₹ 35,444.28 ₹ 30,417.35 ₹ 27,601.96
PV of All Costs ₹ 2,51,199.01
Total Projects Benefits-Costs ₹ -97,937.58 ₹ 29,915.26 ₹ 46,247.08 ₹ 52,951.49 ₹ 59,173.30 ₹ 90,349.55
Yearly NPV ₹ -94,170.75 ₹ 27,658.34 ₹ 41,113.48 ₹ 45,263.15 ₹ 48,636.14
Cumulative NPV ₹ 74,260.74

Related Solutions

Use Excel to calculate the values to fill in the empty boxes. Feel free to add...
Use Excel to calculate the values to fill in the empty boxes. Feel free to add additional tables and calculations as needed. Please use the assignment 1 discussion board to ask questions. Once completed, save this file and upload it in Canvas. Historical Demand Data 2012 to 2016: The table reproduced below is the demand data for a company (aggregated) for the previous five years. 2012 2013 2014 2015 2016 Q1 11632 15034 16117 15565 16470 Q2 22509 26824 24169...
Use Excel to calculate the values to fill in the empty boxes. Feel free to add...
Use Excel to calculate the values to fill in the empty boxes. Feel free to add additional tables and calculations as needed. Historical Demand Data 2012 to 2016: The table reproduced below is the demand data for a company (aggregated) for the previous five years. 2012 2013 2014 2015 2016 Q1 11632 15034 16117 15565 16470 Q2 22509 26824 24169 20151 42858 Q3 21646 13314 14505 13392 19278 Q4 11355 10698 11176 10613 13934 Annual Demand 67,142 65,870 65,967 59,721...
Calculate and fill in the missing values in the table below Moon Distance from Jupiter Period...
Calculate and fill in the missing values in the table below Moon Distance from Jupiter Period Io 42 hours Europa 6.71105km Callisto 17 days Ganymede 1.07106km 172 hours
Use the values provided in the table below to calculate ΔGrxn in kJ at 298 K...
Use the values provided in the table below to calculate ΔGrxn in kJ at 298 K for the combustion of 1 mole of sucrose, C12H22O11. Substance ΔHf°, kJ/mol Sf°, J/mol∙K C12H22O11 (s) -2222 360 O2 (g) 0 205 CO2 (g) -394 214 H2O (g) -242 189
Fill in the following table, supplying all the missing information. Use this information to calculate the...
Fill in the following table, supplying all the missing information. Use this information to calculate the security’s beta. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Enter your Return Deviations answers as a whole number percentage. Round Squared Deviations, Product of Deviations answers to 5 decimal places and Security's beta answer to 2 decimal places. Omit the "%" sign in your response.)...
Use ALL the data found in the Excel file for your analysis. Calculate the following: Run...
Use ALL the data found in the Excel file for your analysis. Calculate the following: Run the descriptive statistics for BMI (Body Mass Index) and SysBP (Systolic Blood Pressure), including graphing a scatter plot of BMI by SysBP. Calculate the correlation between BMI and SysBP. Calculate the regression with SysBP as the response variable (y) and BMI as the explanatory (sometimes called “Independent”) variable (x). In other words, we want to see how much BMI predicts SysBP. Is there a...
Use ALL the data found in the Excel file for your analysis. Calculate the following: Run...
Use ALL the data found in the Excel file for your analysis. Calculate the following: Run descriptive statistics for all the groups. Calculate an equal variance independent samples t-test for SysBP1 vs. SysBP2. Run an ANOVA for just SysBP1 and SysBP2. Note how the results of the t-test and ANOVA compare. Run an ANOVA using all three groups. If you reject the null hypothesis, use the post hoc analysis shown in the Activity 3 Excel file SysBP1 148 114 120...
4. Use Table II below to estimate costs for a company. Reporting Period (Month) Total Production...
4. Use Table II below to estimate costs for a company. Reporting Period (Month) Total Production Costs Level of Activity (Units Produced) January $460,000 300 February 300,000 220 March 480,000 330 April 550,000 390 May 570,000 410 June 310,000 240 July 440,000 290 August 455,000 320 September 530,000 380 October 250,000 150 November 700,000 450 December 490,000 350 Table II 4a. Plot the level of production and cost data for each period. Insert a trend line and display the R2...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT