The Homework Problem:

The Spreadsheet that goes along with the Problem:NIA Spreadsheet Problem

Steps:

1. Enter all data given onthe spreadsheet.Some items will appear more than once.

2. Look to see where you have the most data to find a starting point.

3. If you have numbers in all of the big boxes, you may add them up to get your totals at the bottom of each column.

4. If you have numbers at the bottom and the top (outside the big boxes), you may use the formulas across the top to calculate the numbers at the bottom of the page.

5. Your goal is to find all five numbers at the bottom of the page. You do not need to complete the entire spreadsheet. You may need to back into some of the numbers to solve this problem.

Required: First set of numbers only! The second set are extra practice.Below arehypothetical National Income Accounting Data for an economy.On the NIA sheet that is provided, compute GDP, NDP, NI, and PI.1Depreciation6122Government Expenditures for Goods & Services20163Imports2884Personal Income Taxes9125Transfer Payments5226Exports2167Disposable Personal Income22808Personal Savings2409Gross Private Investment110410Indirect Business Taxes52811Social (Security)Contributions55212Corporate Taxes312Extra practice: (Just double the answers from the first problem to see if you got it!)Below arehypothetical National Income Accounting Data for an economy.On the NIA sheet that is provided, compute GDP, NDP, NI, and PI.1Depreciation1,2242Government Expenditures for Goods & Services4,0323Imports5764Personal Income Taxes1,8245Transfer Payments1,0446Exports4327Disposable Personal Income4,5608Personal Savings4809Gross Private Investment2,20810Indirect Business Taxes1,05611Social (Security)Contributions1,10412Corporate Taxes624