Due date: Monday, October 29, 2018.

Premise.
You are a wandering knight in the realm of Neverfall, lending your services to local nobles, adventurers, merchants, or anyone with a good story. Now it's tax time! The good king Theogen demands that all subjects complete a declaration of revenue and pay any applicable taxes.

The country's currency is made of gold and silver, with 1000 silver to a gold. So you will declare your revenue in terms of gold amount, and the numbers have to show 3 decimals, representing the amount of silver. For example, 31.528 means 528s + 31g.

Project (30 pts).
Create a Microsoft Excel workbook with one worksheet where you will calculate your royal tax return. The first row should contain a title in bold and centered over the page, with the text "Neverfall Tax Return". Use an 11-point font and make sure that the column widths are large enough for each title and number on the page to be fully visible, but not much larger than they need to be (they can vary from column to column). If the text is too long in a column, you can use text wrap, but in that case make sure that the row height is adjusted accordingly. Change the label of the worksheet to "Tax Return".

Income Data.
On the second row, write the titles "Income Type", "Income Gold", "Expense Type", "Expense Gold" (without the quotes) in the cells A2 to D2. Each of them should be in bold and centered in its own cell.

Enter at 7 income types, such as "Loot", "Payment by X" (whoever X might be for you - the king, some lady, etc.), "Found", "Army Salary", and so on. Enter an amount for each of them and make sure that they are numbers showing 3 decimals. For example, 120 should show as 120.000, while 31.5 should show as 31.500.

Enter at least 3 expense types, such as "armor", "mount", "gear", etc. Enter an amount for each of them and make sure that they are numbers showing 3 decimals. Make sure that the total expenses are not larger than the total income. Make the Type column aligned left for both the income and the expenses and the gold columns centered.

Total.
Write "Total" in column A under the last income type. Use a formula in the cell to the right of it, in column B, to compute the sum of the amounts written in that column. Repeat the procedure to show the total of the expenses column. Format the data so far so that the column titles all have a border, that the data/text in each column has a border around the whole group of cells. Place a border on each Total cell (the label) as well as on each total amount cell.

Tax Computation.
Write the following titles in the cells E2, F2, G2: "Taxable Income", "Tax Rate", and "Tax". They should also be in bold with a border around each cell. Use a formula to assign to cell E3 the value of the total amount minus the total expenses. Write the number 0.12 in cell F3, representing the tax rate (12%). Then write a formula in cell G3 to compute the tax by multiplying the taxable income in cell E3 by the rate in cell F3. Place a border on each of these 3 cells and mark the amount of the tax in bold and in a different font color. The tax itself should also show 3 decimals.

Pie chart.
Create a pie chart from the income data, showing each type of income as a slice (but not the total). Make sure that the type (or name) for each income entry is also shown on the chart, next to it or in a legend. Add a title to the chart with the text "Income Distribution". Resize the chart so that it's approximately 4 inches by 3 (you can use the Page Layout view for the measurements), and place it below the income data (same worksheet) so that it doesn't cover the text.

Upload to Canvas: the project workbook to Canvas, Assignments, Midterm 2.