Answered step by step
Verified Expert Solution
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
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 statementStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started