50.1K

Verified Solution

Link Copied!

INSTRUCTIONS:

Prepare a data input section in the exact order as given below. Naming of the input 'sheet' should be "INPUT". Do NOT cellprotect the numeric data of this section, as you must allow for the possibility of change to this information. Use the amounts given as a test of your output. Enter Pct as the $\%,$ not decimal $(80\%$ entered as $80,$ not $0\mathrm{.}80).$ Your input should be placed in the following Rows $[1-24]/$Columns $[$A$-$B$],$ with the heading $"...$ INPUT SECTION $..."$ centered over all columns to which it relates: $\backslash$table$[[,A,B,$C$,D,E,$F$,$G$],[1,...$ OUTPUT SECTION $...],[2,,,,,,,],[3,,,,,,,],[4,$Shcedule of COGS,,Income Statement$],[5,$"Heading" Line $2^n,,$"Heading" Line $2^{?}$Item Name

Company Name MLB$,$ Inc.

Item Amount $($$$)$

Inventory, $1/1/24$ $$1,240,000$

Purchases Adjustments $$330,000$

Freight$-$IN $$250,000$

Operating Income $$4,190,000$

Common Dividends $$570,000$

Item Amount $(\%)$

Net Purchases as a $\%$ of Purchases $85$

Inventory, $12/31/24$ as a $\%$ of Cost of Goods Sold $40$

Tax as a $\%$ of Inventory, $12/31/2475$

Tax Rate $20\mathrm{.}00$

Net Income as a $\%$ of Net Sales $37\mathrm{.}50$

Sales Adjustments as a $\%$ of Sales $25\mathrm{.}00$

Total Dividends as a $\%$ of Preferred Dividends $250\mathrm{.}00$

Retained Earnings, $12/31/24$ as a $\%$ of Cost of Goods Available $87\mathrm{.}50$

Item Amount $($shares$)$

Weighted Average Common Shares Outstanding $659,000$

Answer & Explanation Solved by verified expert

See Answer