Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone help me please. Need explanation for the all color blanks, also EBITDA and Target WACC. begin{tabular}{|c|c|c|c|c|c|} hline & A & B & C
Can someone help me please. Need explanation for the all color blanks, also EBITDA and Target WACC.
\begin{tabular}{|c|c|c|c|c|c|} \hline & A & B & C & D & E \\ \hline 36 & & Other Strategic Decision Matters & & & \\ \hline 37 & A) & Debt & & & \\ \hline 38 & 1) & \multicolumn{4}{|c|}{ Venture demand loan can be used as a demand loan provided it does not exceed 70% of accounts receivable. } \\ \hline 39 & & \multicolumn{2}{|l|}{ Long-term Interest rate = Prime +2.5%=9.0%} & & \\ \hline 40 & 2) & \multicolumn{4}{|c|}{ Term loan repayable will now be repayable over 5 years in equal installments. Interest rate adjusted } \\ \hline 41 & & to 8.45% over five year term. & & & \\ \hline 42 & & Maximum borrowing is 40% of Equipment & & & \\ \hline 43 & 3) & \multicolumn{4}{|c|}{ Amended Mortgage to be repayable over 25 years 7.5% per annum - locked for 5 years } \\ \hline 44 & & \multicolumn{3}{|c|}{ Maximum borrowing is 65% of Land and Buildings } & \\ \hline 45 & 4) & \multicolumn{3}{|c|}{ Refinance term loan - to be completed when transactions completed } & \\ \hline 46 & & - Interest rate proposed & & 10.00% & \\ \hline 47 & & - Maximum borrowing capacity & & $10,000,000 & \\ \hline 48 & & - Repayment & & \multicolumn{2}{|c|}{10 years equal principal payments } \\ \hline 49 & & & & & \\ \hline 50 & B) & Equity & & & \\ \hline 51 & & Shares issued and outstanding & & 4,000,000 & Pre-split - consider when refinancing \\ \hline 52 & & \multicolumn{3}{|l|}{ Share price - based on Year 1 EBITDA X Multiplier } & \\ \hline 53 & & EBITDA - Board approved financials & & v & Determine from Board approved financials \\ \hline 54 & & Multiplier & & 5.00 & \\ \hline 55 & & Current market value & & $ & \\ \hline 56 & & Share price & & $ & Pre-split - consider when refinancing \\ \hline 57 & & Dividends & & $ & \\ \hline 58 & & Cost of Equity Long Range Target & & 18.50% & \\ \hline 59 & & \multicolumn{3}{|c|}{ Assumed to remain constant for transactions planned } & \\ \hline 60 & & Minimum ownership position - founders & & 52% & \\ \hline 61 & & Venture capital share price "discount" & & 27.00% & \\ \hline 62 & & Private placement market price & & $ & \begin{tabular}{l} Pre-split - consider when refinancing - \\ rounded to nearest whole $ \end{tabular} \\ \hline 63 & & & & & \\ \hline 64 & C) & Other information & & & \\ \hline 65 & & Tax Rate - Pro-forma Years (future) & & 26% & Use for target WACC \\ \hline 66 & & Risk premiums & & & \\ \hline 67 & & - Equipment & & 2.50% & \\ \hline 68 & & - Business acquisitions & & 4.50% & \\ \hline 69 & & & & & \\ \hline 70 & D) & WACC & & & \\ \hline 71 & & Target WACC & & 0.00% & from Target WACC tab \\ \hline 72 & & Range of Tolerance for Next Year & & +/.5% & Range for 2B \\ \hline 73 & & & & Low & \\ \hline 74 & & & & 0.50% & \\ \hline 75 & & & & High & \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline A & B \\ \hline Balance Sheet & Approved \\ \hline As at & October 312024 \\ \hline \multicolumn{2}{|l|}{ Assets } \\ \hline \multicolumn{2}{|l|}{ Current assets } \\ \hline Cash & 988,887 \\ \hline Accounts receivable & 5,320,000 \\ \hline Inventory & 6,128,640 \\ \hline \multirow[t]{2}{*}{ Prepaid expenses } & 38,615 \\ \hline & 12,476,142 \\ \hline \multicolumn{2}{|l|}{ Property, plant and equipment } \\ \hline Land & 1,690,000 \\ \hline Buildings & 2,710,000 \\ \hline Equipment & 1,842,000 \\ \hline \multirow[t]{2}{*}{ Vehicles } & 480,000 \\ \hline & 6,722,000 \\ \hline \multicolumn{2}{|l|}{ Less: Accumulated amortization } \\ \hline Accumulated amortization - Buildings & (276,024) \\ \hline Accumulated amortization - Equipment & (149,725) \\ \hline \multirow[t]{3}{*}{ Accumulated amortization - Vehicles } & (48,890) \\ \hline & (474,639) \\ \hline & 4,814,999 \\ \hline \multirow[t]{2}{*}{ Goodwill and other intangibles } & 690,000 \\ \hline & 19,413,503 \\ \hline \multicolumn{2}{|l|}{ Liabilities and Shareholders' Equity } \\ \hline \multicolumn{2}{|l|}{ Current liabilities } \\ \hline Accounts payable & 7,660,800 \\ \hline Deferred revenue & 300,000 \\ \hline Income taxes payable & 655,142 \\ \hline Venture short term loan - due on demand & 3,965,811 \\ \hline \multirow[t]{2}{*}{ Current portion of long term debt } & 195,000 \\ \hline & 12,776,752 \\ \hline Term loan payable & 1,280,000 \\ \hline Refinance term loan & - \\ \hline Mortgage payable & 1,050,000 \\ \hline \multirow[t]{2}{*}{ Due to Relatives } & - \\ \hline & 2,330,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline ivivisyuyu puyuniv & \begin{tabular}{l} B \\ i,vuv,vuv \end{tabular} \\ \hline \multirow[t]{2}{*}{ Due to Relatives } & - \\ \hline & 2,330,000 \\ \hline \multirow[t]{2}{*}{ Less: portion due within one year } & (195,000) \\ \hline & 2,135,000 \\ \hline \multirow[t]{2}{*}{ Deferred income taxes } & 438,812 \\ \hline & 15,350,564 \\ \hline \multicolumn{2}{|l|}{ Shareholders' Equity } \\ \hline Share capital & 1,902,807 \\ \hline \multirow[t]{3}{*}{ Retained earnings } & 2,160,132 \\ \hline & 4,062,939 \\ \hline & 19,413,503 \\ \hline \multirow{3}{*}{\begin{tabular}{l} Growing Soils Ltd. \\ Income Statement \\ Year Ended \end{tabular}} & Board \\ \hline & Approved \\ \hline & October 312024 \\ \hline Revenues & 42,560,000 \\ \hline Cost of goods sold & 30,643,200 \\ \hline \multirow[t]{2}{*}{ Gross profit } & 11,916,800 \\ \hline & 28.00% \\ \hline \multicolumn{2}{|l|}{ Expenses } \\ \hline Selling & 5,178,500 \\ \hline Administrative & 2,764,153 \\ \hline Amortization & 474,639 \\ \hline \multirow[t]{2}{*}{ Interest } & 540,423 \\ \hline & 8,957,714 \\ \hline Income before income taxes & 2,959,086 \\ \hline \multicolumn{2}{|l|}{ Income tax expense } \\ \hline - current & 655,142 \\ \hline - deferred & 143,812 \\ \hline Income tax expense & 798,953 \\ \hline Net income & 2,160,132 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multirow{3}{*}{\begin{tabular}{l} Mortgage payable \\ Due to Relatives \end{tabular}} & 1,050,000 \\ \hline & - \\ \hline & 2,330,000 \\ \hline \multirow[t]{2}{*}{ Less: portion due within one year } & (195,000) \\ \hline & 2,135,000 \\ \hline \multirow[t]{2}{*}{ Deferred income taxes } & 438,812 \\ \hline & 15,350,564 \\ \hline \multicolumn{2}{|l|}{ Shareholders' Equity } \\ \hline Share capital & 1,902,807 \\ \hline \multirow[t]{3}{*}{ Retained earnings } & 2,160,132 \\ \hline & 4,062,939 \\ \hline & 19,413,503 \\ \hline \\ \hline Growing Soils Ltd. & Board \\ \hline \multirow{2}{*}{\begin{tabular}{l} Income Statement \\ Year Ended \\ \end{tabular}} & Approved \\ \hline & October 312024 \\ \hline Revenues & 42,560,000 \\ \hline Cost of goods sold & 30,643,200 \\ \hline \multirow[t]{2}{*}{ Gross profit } & 11,916,800 \\ \hline & 28.00% \\ \hline \multicolumn{2}{|l|}{ Expenses } \\ \hline Selling & 5,178,500 \\ \hline Administrative & 2,764,153 \\ \hline Amortization & 474,639 \\ \hline \multirow[t]{2}{*}{ Interest } & 540,423 \\ \hline & 8,957,714 \\ \hline Income before income taxes & 2,959,086 \\ \hline \multicolumn{2}{|l|}{ Income tax expense } \\ \hline - current & 655,142 \\ \hline \multirow{2}{*}{\begin{tabular}{l} - deferred \\ Income tax expense \end{tabular}} & 143,812 \\ \hline & 798,953 \\ \hline Net income & 2,160,132 \\ \hline Retained earnings, beginning & - \\ \hline Less: Dividends & - \\ \hline Retained earnings, ending & 2,160,132 \\ \hline \end{tabular}Step 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