Accounting/Economics Help Please

Below is the Balance Sheet data. Complete the balance sheet using the Excel template. Hint: you will need to calculate the Retained Earnings Value.

Balance Sheet Data:

Excel Templete:

1. Cash $1,740 2. Accounts Receivable $2,500 3. Inventories $900 4. Bad Debt Provision $-75 5. Accounts Payable $1050 6. Notes Payable $500 7. Accrued Expenses $125 8. Long-term Liabilities $950 9. Land $475 10. Plant and Equipment $3100 11. Accumulated depreciation $1060 12. Stock $680 13. Capital surplus $45 14. Retained Earnings (Value Not Given) Assets Current Assets Liabilities Current Liabilities Cash 1,740 Total Current Assets 1,740 Long-term liabilities Total Liabilities 950 950 Fixed Assets Equity Total Fixed Assets Total Equity Total Liab. And Equity Total Assets 1,740 950