Financial Statement

$1.$ Use the the trial balance found in chapter $4$ Financial Accounting problem $4-1$A $($content copied below$).$ Rename the company name as your name $($example:$$ Jacob Petersen Company$)$

$2.$ Create a new excel file containing $4$ tabs$.$ Each tab should be named and contain the following:

a$.$ Input:$$ Enter all values on this tab including your name, title of the financial statements, and financial accounts and numbers

b$.$ IS: Prepare an income statement using only formulas and cell references from the input tab

c$.$ RE: Prepare a retained earnings statement using only formulas and cell references from the input tab

d$.$ BAL: Prepare a balance sheet using only formulas and cell references from the input tab.

$3.$ Format the reports so they are consistent, easy to ready, and can be printed with information centered on one page.$$ Fonts should be changed from the default text.$$ A mixture of bold and color should be used to make the reports easy to read when printed on a black$/$white printer.$$

$4.$ Print to PDF all $4$ tabs and upload to assignments on D$2$L

$5.$ Print to PDF all $4$ tabs formulas and upload to assignments on D$2$L$.$

$$

Grading is based on the accuracy of the reports, formulas used to present the information, presentation of the data.$$

See below financial statements as an example of how the financial statements could look when competed $($no need to create the arrows and special highlighting of numbers related to the arrows$),$ and to show you how the financials are prepared using the trial balance information.