Analyze, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of ADP Inc.

Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places.

use the data in the photos to solve the missing values highlighted in blue on the final photo.

Analyre, Forecast, and interpret income statement and Balance sheet Following are the income statement and balance sheet of NDP inc. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places: \begin{tabular}{|c|c|c|} \hline Assungtions & & \\ \hline Total reverue womth & 13.00N & gowth. \\ \hline CAPDX as a percentage of total revitivue & 1.10K & X of total revenue \\ \hline Depreciation & \$184 & milise \\ \hline Acauired intarylibles as a percentage of total fevenue & 2.50% & W of lotal revinue \\ \hline Amortikation & 5276 & milion \\ \hline Provision for income tams & 25.00N & X porcentage of earsines befone noeme taons in 2020 \\ \hline Tares parabie & 7.70K & X of provision for inosme taves in 2020 \\ \hline \multirow[t]{2}{*}{ Stock based compensatian } & $167 & increases Copital in escess of par value by the same amount. Astume bat the company \\ \hline & & reutinely includes this foef of compensizion in aperating expances each waz. \\ \hline Stock repirchases & 5750 & \\ \hline Dividends & 51,369 & milion - \\ \hline Dividends pawable & 26.30% & Kof diveres \\ \hline Goodwil, love term dete, preferiod stock, common sted, & & Na charge in s ameunt: \\ \hline and Accumdated other comprehtsulve loss & & = \\ \hline & & \\ \hline \end{tabular} Thes in MBC, enter be answers wath two decimal paces. AUTOMATIC DATA PROCESSING INC. Statement of Consolidated Earnings For Year Ended June 30, 2020, \$ millions \begin{tabular}{|l|r} \hline Total revenues & $12,814.2 \\ \hline Operating expenses & 6,460.21 \\ \hline Systems development and programming costs & 719.01 \\ \hline Depreciation and amortization & 460.5 \\ \hline Total cost of revenues & 7,639.72 \\ \hline Selling, general, and administrative expenses & 2,769.63 \\ \hline Interest expense & 104 \\ \hline Total expenses & 10,513.35 \\ \hline Other (income) expense, net & (89) \\ \hline Earnings before income taxes & 2,389.85 \\ \hline Provision for income taxes & 597.46 \\ \hline Net earnings & 1,792.39 \\ \hline \end{tabular}