Reviewing the financials

In this exercise, you will calculate the subtotals and net income in the Last Year column.

To follow along with all exercises on your local computer, you can find all the course material here.

Congratulations on being hired by Streit! Your first task is to complete an acquisitions model to analyze the purchase of a run-down apartment complex, West Ridge North, that Streit is interested in buying it to renovate it and make it livable. The seller, Shady Tree Management, has provided an income statement for the last year; it's up to you to calculate the subtotals and net income.

Depending on the number of variables, your formulas will most likely look like: SUM(___,___,___)