Problem #$1.$ The numbers in column D are rates that apply to each line item. $-$ i$.$e$.$ D$13$ represents the annual depreciation rate. The depreciation during the observation period can be calculated using this rate. Likewise, D$22$ represents the WAVG $($overall$)$ interest rate on the LT debt of the company. In the Income Statement, CGS is of a typical retail business, not manufacture. Depreciation in G$20$ must correspond to the depreciation in the balance sheet. Numbers in column I are ratios of the corresponding line items which are fractions marked to the sales revenue. Accordingly, I$29$ represents tax rate.

SHOW ALL WORK $,$ DO IT IN EXCEL NEED ALL EXPLANATION AND ALL AREAS FILLED IN WITH EXPLANATION ON HOW ITS DONE