Posted: April 20th, 2022

INSTRUCTIONS:
NOT FOLLOWING THE INSTRUCTIONS WILL COST YOU. HAVING INCORRECT
ANSWERS BECAUSE OF FORMAT WILL NOT BE FORGIVEN. READ CAREFULLY THE
INSTRUCTIONS.
For every of the issues you will have to make use of your Scholar ID quantity. The final 4 digits of
your ID quantity are for use as A, B, C and D. For instance, in case your pupil ID is 35621215: A = 1, B = 2,
C = 1, and D = 5. Due to this fact, for any time that A seems as a quantity, you could use 1, for B you’ll use 2
and so forth. DUE DATE IS Friday April 15, 2022. NO LATE SUBMISSIONS.
FOR THE FOLLOWING PROBLEMS YOU DON’T HAVE TO SHOW PROCESS, JUST THE
ANSWERS IN AN EXCEL DOCUMENT (“ANSWERS, EXAM three.XLSX”). Every of the
questions has a particular cell so that you can put your solutions. You MUST submit the excel
doc. Submitting a PDF doc is non-compulsory.
ANSWER IN PERCENTAGE FOR PERCENTAGE ANSWERS. In case your reply is zero.0405,
then reply four.05. DO NOT USE %.
ANSWER IN DOLLARS FOR NUMERICAL NUMBERS, USE FOUR DECIMALS. In case your
reply is 100M you have to enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
HOW TO FILL OUT THE EXCEL DOCUMENT:
Scholar ID: Cell A2
Downside 1, A: Cell B2
Downside 1, B: Cell C2
Downside 2, A: Cell D2
Downside 2, B: Cell E2
Downside 2, C: Cell F2
Downside 2, D: Cell G2
Downside three, A: Cell H2
Downside three, B: Cell I2
Downside three, C: Cell J2
Downside three, D: Cell K2
Downside three, E: Cell L2
Downside three, F: Cell M2
Downside three, G: Cell N2
Downside three, H: Cell O2
1) Medtronic agency has $[(1,000,000*(A+B)+$55,000,000] in fairness and $55,000,000 in debt
and forecast $[(1,000,000*(C)+$22,000,000] in web revenue for the 12 months. It presently pays
dividends equal to [(A+B+C+D)]% of its web revenue.
a. What would their inner development fee be?
NOTE: Reply in share. In case your reply is zero.0405, then reply four.05.
b. What would their sustainable development fee be?
NOTE: Reply in share. In case your reply is zero.0405, then reply four.05.
2) For the next issues, use Exhibit A. For exhibit A, the quantity of gross sales will depend on
the manufacturing quantity proven beneath. The dividend coverage is to pay [21+D+C]% in
dividends. Assemble the Manufacturing quantity desk based mostly in your pupil ID quantity as per
the directions proven beneath.
a. What would be the depreciation for 2023?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
b. What would be the Stock for 2025?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
c. What would be the accounts payable for 2024?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
d. Think about that the company decides to make use of debt for any exterior financing, what
can be the quantity of debt in 2022? (If no web new financing is required, then
reply with a unfavorable quantity)
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
three) For the next issues, use Exhibit B. Exhibit B has the steadiness sheet and Revenue
Assertion project ( help with nursing paper writing from experts with MSN & DNP degrees)ions for a particular firm. The corporate is evaluating whether it is price it
to have the capital funding as confirmed within the Capital Funding Desk. The EBITDA
multiplier of comparable corporations [(D+5.2)]. The debt used has a coupon of [(C+3.5)]%. The
WACC is [7+C+D+2]%.
a. What’s the enhance in Internet Working Capital for 2022?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
b. What’s the enhance in Internet Working Capital for 2023?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
c. What can be the Free Money Move for 2022?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
d. What can be the Free Money Move for 2023?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
e. What’s the current worth of the Free money flows?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
f. What’s the current worth of the continuation worth for the agency?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
g. What’s the current worth of the Curiosity Tax Defend?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
h. What’s the Agency Worth with the growth of the venture?
NOTE: Present your solutions in dollars. E.G. for 100M you have to
enter 100000000.000zero, for 20M you have to enter 20000000.000, and many others.
2021 2022 2023 2024 2025 2026
Revenue Assertion
1 Gross sales Income $ 37,500.00
2 much less: Price of Items Bought 29,625.00 $
three EBITDA $ 7,875.00
four much less: Depreciation Expense four,125.00 $
5 EBIT $ three,750.00
6 much less: Curiosity and Different Bills 750.00 $
7 PRE-TAX INCOME $ three,000.00
eight much less: Revenue Tax 1,050.00 $
9 NET INCOME 1,950.00 $
Manufacturing Quantity (000s items)
1 Market Dimension $ 10,000.00 $ 10,300.00 $ 10,609.00 $ 10,927.27 $ 11,255.09 $ 11,592.74
2 Market Share 10.00% [10+(D/2)+2]% [10+2*(D/2)+4]% [10+3*(D/2)+6]% [10+4*(D/2)+8]% [10+5*(D/2)+10]%
three Manufacturing Quantity (Market Dimension X Market Share) 1000.00
four Common Gross sales Worth $37.50 $38.25 $39.02 $39.80 $40.59 $41.40
Built-in Monetary Statements
Exhibit A: Professional Forma Monetary Statements
DEPARTMENT OF BUSINESS AND ECONOMICS BBA 308 | EXAM three Company Finance
2021 2022 2023 2024 2025 2026
Built-in Monetary Statements
Exhibit A: Professional Forma Monetary Statements
Stability Sheet
1 ASSETS
2 Money and Equivalents 6,375.00 $
three Accounts Receivable 6,750.00 $
four Stock 7,125.00 $
5 CURRENT ASSETS 20,250.00 $
6 Property, Plant and Tools 21,375.00 $
7 TOTAL ASSETS 41,625.00 $
eight LIABILITIES AND EQUITY
9 Accounts Payable eight,625.00 $
10 CURRENT LIABILITIES eight,625.00 $
11 Lengthy-Time period Debt 7,500.00 $
12 TOTAL LIABILITIES 16,125.00 $
13 STOCKSHOLDER’S EQUITY 25,500.00 $
14 Retained Earnings – $
15 TOTAL EQUITY 25,500.00 $
16 TOTAL LIABILITIES AND EQUITY 41,625.00 $
DEPARTMENT OF BUSINESS AND ECONOMICS BBA 308 | EXAM three Company Finance
2021 2022 2023
Revenue Assertion
1 Gross sales Income $ 52,360.00 $ 77,513.27 $ 105,077.99
2 much less: Price of Items Bought $ 41,364.40 $ 61,235.48 $ 83,zero11.61
three EBITDA $ 10,995.60 $ 16,277.79 $ 22,066.38
four much less: Depreciation Expense $ 5,759.60 $ eight,526.46 $ 11,558.58
5 EBIT $ 5,236.00 $ 7,751.33 $ 10,507.80
6 much less: Curiosity and Different Bills $ 650.00 $ 650.00 $ 6,150.00
7 PRE-TAX INCOME $ four,586.00 $ 7,101.33 $ four,357.80
eight much less: Revenue Tax $ 1,605.10 $ 2,485.46 $ 1,525.23
9 NET INCOME $ 2,980.90 $ four,615.86 $ 2,832.57
Stability Sheet
1 ASSETS
2 Money and Equivalents $ eight,901.20 $ 13,177.26 $ 17,863.26
three Accounts Receivable $ 9,424.80 $ 13,952.39 $ 18,914.04
four Stock $ 9,948.40 $ 14,727.52 $ 19,964.82
5 CURRENT ASSETS $ 28,274.40 $ 41,857.16 $ 56,742.11
6 Property, Plant and Tools $ 29,845.20 $ 44,182.56 $ 59,894.45
7 TOTAL ASSETS $ 58,119.60 $ 86,zero39.73 $ 116,636.56
eight LIABILITIES AND EQUITY
9 Accounts Payable $ 12,042.80 $ 17,828.05 $ 24,167.94
10 CURRENT LIABILITIES $ 12,042.80 $ 17,828.05 $ 24,167.94
11 Lengthy-Time period Debt $ 6,500.00 $ 61,500.00 $ 61,500.00
12 TOTAL LIABILITIES $ 18,542.80 $ 79,328.05 $ 85,667.94
13 STOCKSHOLDER’S EQUITY $ 39,576.80 $ 74,134.00 $ 74,134.00
14 Retained Earnings $ – $ three,692.69 $ 2,266.06
15 TOTAL EQUITY $ 39,576.80 $ 77,826.69 $ 76,400.06
16 TOTAL LIABILITIES AND EQUITY $ 58,119.60 $ 157,154.74 $ 162,067.99
Internet Working Capital Necessities
1 Present Property
2 Present Liabilities
three Internet Working Capital
four Enhance in Internet Working Capital
Capital Funding
1 Capital Funding $ 2,500.00 $ 57,500.00 $ eight,500.00
Built-in Monetary Assertion Template
Exhibit B: Free Money Move and Valuation
DEPARTMENT OF BUSINESS AND ECONOMICS BBA 308 | EXAM three
Company Finance
2021 2022 2023
Built-in Monetary Assertion Template
Exhibit B: Free Money Move and Valuation
Free Money Move (000s)
1 Internet Revenue
2 Plus: After-Tax Interes Expense
three Unlevered Internet Revenue
four Plus: Depreciation
5 Much less: Will increase in NWC
6 Much less: Capital Expenditures
7 Free Money Move of Agency
Valuation of the Development
1 Free Money Move of the Agency
2 PV of the Money Move
three Continuation Worth
four PV of Continuation Worth
5 web Curiosity Expense
6 Curiosity Tax Defend
7 PV Curiosity Tax Defend
eight Agency Worth
DEPARTMENT OF BUSINESS AND ECONOMICS BBA 308 | EXAM three
Company Finance

Order | Check Discount

Tags: Write my dissertation in a week, Write my dissertation Ireland, Write my dissertation literature review, Write my dissertation proposal, Write my essay 4 me