Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

It looks like you have provided a breakdown of the sources and uses of funds for a startup, along with details of equity, loans, and

image text in transcribed

It looks like you have provided a breakdown of the sources and uses of funds for a startup, along with details of equity, loans, and the application of funds. If you need assistance with solving this in an Excel sheet, you can follow these steps:

Create a new Excel spreadsheet.

Label your columns:

Column A: Categories (e.g., Equity, Loan/debt, Organizational Costs, Equipment, etc.) Column B: Amount Enter the data:

In Column A, list all the categories mentioned in your breakdown. In Column B, input the corresponding amounts. Calculate Total Sources of Funds:

In a new cell, use the formula =SUM(B2:B3) to calculate the total sources of funds. Calculate Total Application of Funds:

In a new cell, use the formula =SUM(B7:B11) to calculate the total application of funds. Calculate Total Debt Requirements:

In a new cell, use the formula =B8-B16 to calculate the total debt requirements. Format your spreadsheet:

You can format cells as currency for better readability. You may want to use different colors or bold text to highlight important information.

Start Up Application of Funds SOURCES OF FUNDS Amount $152,000=$107,000+$45,000 Equity Loan/debt Total Sources of Funds APPLICATION \{USES\} DF FUNDS General Start-Up Costs Organizational Cost5 Pre-paid Expenses Opening Inventory Flxed Assets Equipment Auto/Truck Leasehold Improvements Cash Reserve Fund Total Application of Funds (Funds recd) Subtract: Equity Total Debt Requirements $3,000.00 52,000,00 40,000.00 50,000.00 7,000.00 $152,000 45,000 107,000 PROFORMA OPENING BALANCE SHEET ASSETS Current Assets Cash \& Marketable Securities $7,000 Accounts Receivable Inventory/office supplies Prepaid expenses Other current assets Total Current Assets 7,000 Fixed Assets Equipment/furniture/fixtures Leasehold improvements Land/buildings Auto/truck Other fixed assets Intangible Assets Organization fees (legal, accounting etc.) Total Fliced Assets 142,000 52,000 50,000 40,000 Total Flyed Assets 3,000 Total Intangible Assets 3,000 TOTAL ASSETS LABILITIES Current Liabilities Lone-term loans (curtent portion) Short-term loans Accounts payable Other current liabilitles Total Current Liablities 7,000 Long-term Llabllitles Long-term loans (less current portion) 100,000 Mortgages and liens payable Loans from shareholders ( if applicable) Other long-term debt obllgatlons Total Long Term Debt TOTAL DEBT 100,000 EQUITY Common Stock/Owner's Capital Start Up Application of Funds SOURCES OF FUNDS Amount $152,000=$107,000+$45,000 Equity Loan/debt Total Sources of Funds APPLICATION \{USES\} DF FUNDS General Start-Up Costs Organizational Cost5 Pre-paid Expenses Opening Inventory Flxed Assets Equipment Auto/Truck Leasehold Improvements Cash Reserve Fund Total Application of Funds (Funds recd) Subtract: Equity Total Debt Requirements $3,000.00 52,000,00 40,000.00 50,000.00 7,000.00 $152,000 45,000 107,000 PROFORMA OPENING BALANCE SHEET ASSETS Current Assets Cash \& Marketable Securities $7,000 Accounts Receivable Inventory/office supplies Prepaid expenses Other current assets Total Current Assets 7,000 Fixed Assets Equipment/furniture/fixtures Leasehold improvements Land/buildings Auto/truck Other fixed assets Intangible Assets Organization fees (legal, accounting etc.) Total Fliced Assets 142,000 52,000 50,000 40,000 Total Flyed Assets 3,000 Total Intangible Assets 3,000 TOTAL ASSETS LABILITIES Current Liabilities Lone-term loans (curtent portion) Short-term loans Accounts payable Other current liabilitles Total Current Liablities 7,000 Long-term Llabllitles Long-term loans (less current portion) 100,000 Mortgages and liens payable Loans from shareholders ( if applicable) Other long-term debt obllgatlons Total Long Term Debt TOTAL DEBT 100,000 EQUITY Common Stock/Owner's Capital

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

Excel Accounting

Authors: Carol Yacht, Michael Fujita

1st Edition

0072987812, 978-0072987812

More Books

Students also viewed these Accounting questions

Question

How can performance standards create functional silos?

Answered: 1 week ago

Question

Q.No.1 Explain Large scale map ? Q.No.2 Explain small scale map ?

Answered: 1 week ago