Answered step by step
Verified Expert Solution
Link Copied!
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

image text in transcribedimage text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

International Finance Transactions Policy And Regulation

Authors: Hal Scott, Anna Gelpern

21st Edition

1634602048, 978-1634602044

More Books

Students explore these related Finance questions

Question

What do you think your problem does to you?

Answered: 3 weeks ago