First, read the following case on the Student Housing Decision.

Finally, complete the following assignment.

Villanueva received the analysis of the student housing decision (as evidenced in the videos above). However, the file became corrupted and now most of the data has vanished along with applicable formulas and calculations. Villanueva asks that you conduct a brief analysis using the spreadsheet below. Provide your answers in the second tab of the spreadsheet, making sure to include calculations and explanations where appropriate.