開始使用免費開始

Format a balance statement model

You will now create a balance statement model for the Grape Debate Wine Company. They want to format the statement using financial settings. Even though equity and liabilities are money owed, they are usually represented as positive numbers in these documents.

Each section will have a subtotal, using the sum() function, and the final total for equity and liabilities should be the total of those two sections.

本練習屬於課程

在 Google Sheets 進行財務建模

檢視課程

練習說明

  • Format the numerical data in Financial format (excluding the Years).
  • Using the sum() function, create subtotals in B11, B18, and B23.
  • Using the sum() function, create a total for Equity and Liabilities in B25.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習