Need these answered fully with excel as well as the work/image attached underneath each question from the spreadsheet. This is due Sunday 3/21 at 11:00 pm. Thanks!

*NO CHEGG OR COURSEHERO

## Cost Estimation & Financial Analysis

### Examination #2

## General Information and Instructions

### Test Value and Point Structure

The exam is worth 15% of the final grade. It is graded on a 100-point scale.

### General

1. Read every question carefully.

i. If you have multiple spreadsheets append a number to the naming format

b. Your work should be submitted as two attachments (as indicated above). Your answers should be presented as a report in a text document and include all conclusions (& include all charts, tables, and snapshots of your excel file). You should clearly state where assumptions are being made. Your spreadsheets must SHOW all calculations/work.

### Formatting

1. There are no page limitations. Make your point concisely, precisely, & convincingly

2. Use a 12-point font for ease of reading

3. Use graph/charts/tables to clearly convey a point

4. Be sure to clearly state your conclusions

### Note on grading & partial credit

Grading is primarily based on the materials that you present in the report (i.e. provided in your .pdf document). The spreadsheets are accessed as necessary to evaluate the appropriate level of partial credit, if any.

*Cumulative Errors:* This exam may require you to reference your own work as you progress through the problem (for example, your own cost estimations may be used to build projected cash flows). All attempts will be made to grade in such a manner that mistakes made early in the assignment do not impact later work – which makes clearly organized spreadsheets critical to quickly assess where mistakes arise.

*Legibility and organization of work:* It is imperative that your report & spreadsheets be of * professional quality *. You are all in professional careers and the quality of your work is assessed immediately. Your work must be clear and easy to follow. This is particularly important for your spreadsheets. I will deduct points for badly written reports.

*I cannot give credit for work I cannot follow or comprehend.*

*Point Weighting:* Points are assigned to each problem/sub-problem. Ensure you address all requested criteria and answer all questions in order to be eligible to receive full credit.

### Due Diligence

It is your responsibility to demonstrate knowledge of the concepts, theories, and techniques being tested. You should apply that knowledge to critically analyze and answer the problems.

### Requirements

Submit your results in the form of a well-supported written report. This means that every table, calculation, number needs to be included. Use diagrams, etc. to synthesize your findings where appropriate. Ensure all information is presented in the written report – the excel spreadsheet will be referenced ONLY for partial credit, if any.

Submit an Excel spreadsheet that contains all working calculations/formulas. The spreadsheet should be tidy and clear. You will forfeit points and incur progressive or cumulative errors if your spreadsheet is not easy to navigate, clearly labeled, or otherwise well organized.