Question: Please help I need to know the formulas as well as how to enter them into excel Tim Dye, the CFO of Blackwell Automotive, Inc.,

Please help I need to know the formulas as well as how to enter them into excel Tim Dye, the CFO of Blackwell Automotive, Inc., is putting together this years financial statements. He has gathered the following balance sheet information: The firm had a cash balance of $23,015, accounts payable of $163,257, common stock of $313,299, retained earnings of $512,159, inventory of $212,444, goodwill and other assets equal to $78,656, net plant and equipment of $711,256, and notes payable of $21,115. It also had accounts receivable of $141,258 and other current assets of $11,223. How much long term debt does
Blackwell Automotive have?
H int: Using the template below, create a Balance Sheet using the figures given above and write a formula in cell H25 to solve for long-term debt.
 Please help I need to know the formulas as well as

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To calculate the longterm debt for Blackwell Automotive follow these steps using Excel Step 1 Enter ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!