Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show all work in Excel and how to complete in Excel. Thank You! 3. Using the data presented below for Blue Sky Inc.: 2017

image text in transcribed

Please show all work in Excel and how to complete in Excel. Thank You!

3. Using the data presented below for Blue Sky Inc.: 2017 2016 Sales $7,550,000 $6,150,000 Cost of Goods 5,750,000 4,550,000 Depreciation 120,000 100,000 Selling and G&A Expenses 730,000 820,000 200,000 Fixed Expenses 200,000 Lease Expense 150,000 150,000 Interest Expense 350,000 300,000 Tax Rate 40.00% 40.00% Shares Outstanding 100,000 80,000 Cash 108,000 50,000 Marketable Securities 150,000 100,000 Accounts Receivable 350,000 450,000 1,250,000 Inventory 850,000 40,000 Prepaid Expenses 120,000 Plant & Equipment 5,350,000 4,800,000 Accumulated Depreciation 410,000 290,000 Long Term Investments 450,000 360,000 380,000 Accounts Payable 420,000 Notes Payable 150,000 100,000 Accrued Expenses 150,000 100,000 Other Current Liabilities 200,000 180,000 Long-term Debt 2,900,000 2,500,000 Common Stock 2,500,000 2,000,000 Additional Paid-in-Capital 600,000 500,000 Retained Earnings 548,000 500,000 Create Blue Sky's income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Make the appropriate note on the heading of each financial statement

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

Monetary Policy Strategy

Authors: Frederic S. Mishkin

1st Edition

0262513374, 978-0262513371

More Books

Students also viewed these Finance questions