September – December 2023 Public finance- cost and benefits i need the spreadsheets with memo
Business & Finance
you need to download a program call @risk for the job.As long as I am able to provide the new case background you can start working on it with the program call @riskhere is the link to free trail to te program @risk : http://www.palisade.com/risk/As the case output would have some distribution graph by using the program @risi need the spreadsheets with memo.if you do the excel files in a wrong way which means the memo could go wrong directionPublic finance- cost and benefitsFinanceThe basic output is a no longer than a 3 page double-space memorandum (this page length EXCLUDES ANY TABLES YOU MIGHT INCLUDE) that describes the analysis, presents the results, and then makes a recommendation whether or not Safer Choices is a program local school districts should promote, with also a recommendation about the financing mechanism. As with the pervious case, your memo should be broken down explicitly into sections with bolded headers as follows:IntroductionAnalysis Method and AssumptionsResultsPolicy RecommendationSee memo for Cincinnati Vehicle Emissions Inspections case as a model for this kind of policy/decision memo. Also, revise the writing style below.Your assessment should be based on four figures/tables.Figure 1 shows the NPV distribution of the program for non-college educated students, with the summary statistics @Risk provides (mean, standard deviation, minium, maximum, etc.) Also, do the overlay that shows the kind of distribution generated.Figure 2 shows the NPV distribution of the program for college-educated students, with the summary statistics @Risk provides (mean, standard deviation, minimum, maximum, etc.) Also, do the overlay that shows the kind of distribution generated.Table 3 is KHT 1 based on the mean estimated from the distributions in either Table 1 or Table 2.Table 4 is KHT2 based on the means estimated from the distribution you chose for KHT1. That is, do either non-college educated or college-educated for both the KHTs.