Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.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: \table[[,A,B,C,D,E,F,G],[1,... OUTPUT SECTION ...],[2,,,,,,,],[3,,,,,,,],[4,Shcedule of COGS,,Income Statement],[5,"Heading" Line 2n,,"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.00
Net Income as a % of Net Sales 37.50
Sales Adjustments as a % of Sales 25.00
Total Dividends as a % of Preferred Dividends 250.00
Retained Earnings, 12/31/24 as a % of Cost of Goods Available 87.50
Item Amount (shares)
Weighted Average Common Shares Outstanding 659,000
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Concepts And Applications

Authors: W. Steve Albrecht, James D. Stice, Earl K. Stice, Monte R. Swain

10th Edition

0324376154, 978-0324376159

More Books

Students also viewed these Accounting questions