Question

In: Accounting

Profit and Loss Statement 2018 Revenue 34,290 percent of growth 0.0% Gross Profit 34,290 Gross Margin...

Profit and Loss Statement 2018
Revenue 34,290
percent of growth 0.0%
Gross Profit 34,290
Gross Margin 100%
SGA Costs (2,500)
EBITDA 31,790
EBITDA Margin 92.7%
Depreciation (7,500)
% of Sales -21.9%
EBIT 24,290
EBIT Margin 70.8%
Interest (2,500)
% of Sales -7.3%
EBIT 21,790
EBIT Margin 63.5%
Net Income 21,790
Net Income Margin 63.5%
Balance Sheet 2017 2018
Cash 9,000 12,000
Inventory 0 0
A/R    0 3,179
Current Assets    9,000 15,179
Fixed Assets 747,300 763,800
Total Assets    756,300 778,979
Liabilities
A/P    16,800 14,460
Current Liabilities 16,800 16,800
Long Term Debt 499,652 468,000
Total Liabilities 516,452 482,460
Total Equity    239,848 296,519
Total Liabilities and Equity 756,300 778,979
Cash Flows 2018
EBIT 24,290
Depreciation 7,500
Interest (2,500)
Working Capital (2,500)
Operating Cash Flow 26,790
Capex (50,000)
Investing Cash Flows (50,000)
Long Term Debt 50,000
Financing Cash Flows 50,000
Cash Flow 26,790
Cash Overdraft 26,790

1. Question is to identify gaps in funding for my property rental business of10 years, using my financial statements 2.What area(s) do you notice a gap in funding (a shortfall in capital needed to fund future operations or projects)? Really evaluate, even if it’s $1,000 or $10,000; identify it. Evaluate those gaps to determine the cause of those gaps. Prioritize your funding needs. Priority for Funding Gap in Funding Example 1. Initial inventory Unsure ,Have not fully identified the amount of initial inventory needed. Example 2 Computer system $5,000 ,Do not have funding to cover this expense. 3 Submit matrix and a 2-page explanation for your prioritization. HOW DO I IDENTIFY FUNDING GAPS, ( A SHORTFALL IN CAPITAL TO FUND FUTURE OPERATIONS Larry I assume they are talking about gaps in working capital whn funding business cash flows.Larry

Solutions

Expert Solution

Step:-1=

1.) What is funding gap?

Ans. A funding gap is the amount of money needed to fund the ongoing operations or future development of a business or project that is not currently by cash, equity or debt. Funding gaps can be covered by investment from venture capital or angel investors, equity sales, or through debtt offerings and bank loans.

Step:-2=

1.) Identification of funding gap?

Ans. First of all check the debt-equity ratio that is whether this ratio is within prescribed limit or not. As per accounting standard concern the ratio must be equal to 2:1, That is Debt should not be more than twice of equity.

Check this ratio in given question as follows:-

S.no. Particulars 2017 2018

1. Long term debt 499652 468000

2. Equity 239848 296519

3. Ratio ( Debt / Equity) 2.08 1.58

Analysis:- As per above statement we can see that ratio is within limit of in 2018 but in 2017 the ratio is little bit more, as per above analysis we can easily find that whether we have to pay interest in more than our earning because interest of debt is burden on company to pay on recurring basis and its effect working capital in a company hence this ration should be in limit.

Step:-3= Cash Flow Statement:-

1.) As you see the cash flow statement and you will find that there is cash overdraft and there is also a major expenditure is done on the area of assets side or capital expenditure so these are the area of due to which funding gap is created.

Extra explanation for understanding Financial Gap:-
The Financial Gap forecasting section provides a tool to understand how a business’ growth (as
measured by its Sales on the Income Statement), can affect its need for additional assets (which are
measured and paid for on the Balance Sheet). The process involves first identifying which assets
and/or liabilities vary with sales. Variable Assets usually include cash, A/R, inventory, and equipment.
Variable Liabilities are usually accruals and A/P. These can vary with different companies.
Once we’ve identified the company’s variable assets and liabilities, we then develop a percentage of
sales relationship between the dollar amounts from the balance sheet of each variable asset and
liability to the sales that were produced during the year. These percentage of sales relationships will
be used to forecast what the balance sheet may look like in the future, based on different levels of
anticipated sales.


Related Solutions

Gross profit $ and gross profit % for Walgreens Gross profit for 2018 = Revenue –...
Gross profit $ and gross profit % for Walgreens Gross profit for 2018 = Revenue – Cost of Goods Sold = 131,537 – 100,745 = $30,792 Gross profit % for 2018 = Gross profit / total sales * 100 = $30,792 / $131,537 *100 = 23.41% Gross profit for 2017 = 118,214 – 89,052 = $29,162 Gross profit % for 2017 = $29,162 / $118,214 *100 = 24,67% Gross profit for 2016 = 117,351 – 87,477 = $29,874 Gross profit...
Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years.
In 2021, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2023. Information related to the contract is as follows:   2021 2022 2023 Cost incurred during the year $ 2,610,000   $ 3,162,000   $ 2,230,800   Estimated costs to complete as of year-end   6,390,000     2,028,000     0   Billings during the year   2,100,000     3,672,000     4,228,000...
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin​ (gross profits÷​sales) of 34 percent...
(Efficiency analysis) The Brenmar Sales Company had a gross profit margin​ (gross profits÷​sales) of 34 percent and sales of $9.3 million last year. 76 percent of the​ firm's sales are on​ credit, and the remainder are cash sales. ​ Brenmar's current assets equal $1.7 million, its current liabilities equal $299,200​, and it has $102,800 in cash plus marketable securities. a. If​ Brenmar's accounts receivable equal $562,300​, what is its average collection​ period? b. If Brenmar reduces its average collection period...
Its gross profit(loss) equals
A company has sales of $7,22,200 and cost of goods sold of $2,89,200.Its gross profit (loss) equals (a) $1,011,240 (b) $2,89,200 (c) $7,22,200 (d) $4,33,000  
Problem 5-10 Part 4 4. Calculate the amount of revenue and gross profit (loss) to be...
Problem 5-10 Part 4 4. Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years assuming the following costs incurred and costs to complete information. (Do not round intermediate calculations and round your final answers to the nearest whole dollar amount. Loss amounts should be indicated with a minus sign.) 2018 2019 2020 Cost incurred during the year $ 2,184,000 $ 3,860,000 $ 3,260,000 Estimated costs to complete as of year-end 5,616,000...
How to explain and classify income statement revenue, gross profit, and net income?
How to explain and classify income statement revenue, gross profit, and net income?
If Gross Profit Margin is 55%, what is COGS %?
If Gross Profit Margin is 55%, what is COGS %?
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods sold, and inventory amounts for three retailers of fine jewelry, Tiffany & Co., Zale Corporation, and Blue Nile, Inc. (an Internet retailer). ($ millions) 2013 2012 Tiffany & Co. Revenues $4,585 $4,017 Cost of goods sold 1,776 1,674 Inventory 2,489 2,347 Zale Corporation Revenues $1,973 $1,910 Cost of goods sold 989 949 Inventory 823 769 Blue Nile, Inc. Revenues $505 $443 Cost of goods...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods sold, and inventory amounts for three retailers of fine jewelry, Tiffany & Co., Zale Corporation, and Blue Nile, Inc. (an Internet retailer). ($ millions) 2013 2012 Tiffany & Co. Revenues $4,231 $3,974 Cost of goods sold 1,766 1,664 Inventory 2,477 2,335 Zale Corporation Revenues $1,963 $1,900 Cost of goods sold 979 939 Inventory 813 759 Blue Nile, Inc. Revenues $495 $433 Cost of goods...
What is the firm's current year gross profit margin?
Category Prior Year Current YearAccounts payable ??? ???Accounts receivable 320,715 397,400Accruals 40,500 33,750Additional paid in capital 500,000 541,650Cash 17,500 47,500Common Stock 94,000 105,000COGS 328,500 428,048.00Current portion long-term debt 33,750 35,000Depreciation expense 54,000 54,731.00Interest expense 40,500 41,017.00Inventories 279,000 288,000Long-term debt 339,670.00 401,877.00Net fixed assets 946,535 999,000Notes payable 148,500 162,000Operating expenses (excl. depr.) 126,000 161,905.00Retained earnings 306,000 342,000Sales 639,000 850,323.00Taxes 24,750 48,686.00What is the firm's current year gross profit margin?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT