Book1
.xls
keyboard_arrow_up
School
Elementary College of Education For Women Skardu *
*We aren’t endorsed by this school
Course
HUMAN RESO
Subject
Finance
Date
Nov 24, 2024
Type
xls
Pages
5
Uploaded by Timwoods
The Financial Numbers
Required Initial Investment=Initial CAPEX+Working CapitalRequired Initial Investment=Initial CAPEX+Working Capital
Capital expenditures
-8,147
Working
capital
-2,518
-10,665
Total revenue as per 2023
99,891
Total revenue as per 2020
50,734
$0.25
Year
Eastimated revenue value
2023
99,891
$125,199.36
2024
$125,199.36
$156,919.84
2025
$156,919.84
$196,677.02
2026
$246,507.06
$308,962.04
2027
$308,962.04
$387,240.59
Find the annual growth rate for every single item on the income statement. Future growth may be predicted using historical
from 2021 to 2022
revenue of 2022
99,891
revenue of 2021
66,070
0.005
from 2020 to 2021
revenue of 2021
66,070
revenue of 2020
50,734
0.0030
Average of these growth rates:
0.0051
Year
Projected Profit
2023
100,404
a.
Required Initial Investment
C.
Projected Profit each year for the next 3 to 5 years.
2024
100919.33
2025
101437.46
2006
101958.25
2027
101958.25
Formula: ((Total Revenue in Current Period) - (Total Revenue in Previous Period)) / (Total Revenue in Previous Period)
Total revenue in current period
99,891
Total Revenue in Previous Period
66,070
51.19
Formula: (Gross Profit / Total Revenue) * 100
Gross Profit
20,731,607
Total Revenue
99,891
20754.23
Operating Margin
Formula: (Operating Income / Total Revenue) * 100
Operating Income is not given
(OperatingIncome=NetOperatingCashFlow−Non−OperatingItems)
Net Operating Cash Flow
7,975
Non Operating Income
-57
7,918
Operating Income
7,918
Total Revenue
Operating Margin
net income
7,918
Total Revenue
99,891
Net Profit Margin:
7.93
Return on Assets (ROA):
Formula: (Net Income / Total Assets) * 100
Net income
16,298
Total Assets
87,950
Return on Assets (ROA):
18.53
D.
Key Financial Performance Metrics
Revenue Growth Rate
:
Gross Margin
:
Gross Margin
:
Return on Equity (ROE):
Formula: (Net Income / Stockholders' Equity) * 100
Net income
16,298
Stockholder's equity
87,950
Return on Equity (ROE):
18.53
Earnings Per Share (EPS):
Formula: (Net Income / Diluted Average Shares)
Net income
16,298
Diluted Average Shares
533
30.58
Current Ratio:
Formula: Current Assets / Current Liabilities
Current Assets
57,769
Current liabilities
18,081
Current Ratio:
3.20
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
UST
The last few years' yearly
CAGR = [(Ending Value /
2024: Approximately $125,199.36
2025: Approximately $75,135,246.03
2026: Approximately $196,677.02
2027: Approximately $$308,962.04
2028: Approximately $$387,240.59
l growth rates. We'll assume consistent growth based on the TTM and data from the previous two years:
y sales growth rate. Use the CAGR formula:
Beginning Value) ^ (1 / Number of Years)] - 1
Related Questions
Year Investment A 2016 $400.000 2017 $400.000 2018 $400.000 2019 $400.000 2020 $400.000
Investment B $100.000 $100.000 $100.000 $1.000.000 $1.000.000 calculate the Npv of both
project
arrow_forward
hsd.1
arrow_forward
1. Consider the following investment projects:
Year(n)
Net cash flow
Project 1
-$1,200
Project 2
-$2,000
1
600
1,500
2
1,000
1,500
IRR
19.65%
17.53%
Determine the range of MARR for which
Project 2 would be preferred over Project 1
arrow_forward
Net Present Value Method, Present Value Index, and Analysis
First United Bank Inc. is evaluating three capital investment projects using the net present value method. Relevant data related to the projects are summarized as follows:
BranchOfficeExpansion
ComputerSystemUpgrade
ATMKioskExpansion
Amount to be invested
$787,317
$584,976
$298,035
Annual net cash flows:
Year 1
391,000
278,000
164,000
Year 2
364,000
250,000
113,000
Year 3
332,000
222,000
82,000
Present Value of $1 at Compound Interest
Year
6%
10%
12%
15%
20%
1
0.943
0.909
0.893
0.870
0.833
2
0.890
0.826
0.797
0.756
0.694
3
0.840
0.751
0.712
0.658
0.579
4
0.792
0.683
0.636
0.572
0.482
5
0.747
0.621
0.567
0.497
0.402
6
0.705
0.564
0.507
0.432
0.335
7
0.665
0.513
0.452
0.376
0.279
8
0.627
0.467
0.404
0.327
0.233
9
0.592
0.424
0.361
0.284
0.194
10
0.558
0.386
0.322
0.247
0.162
Required:
1. Assuming that the desired rate of return is 10%,…
arrow_forward
Complete the table
arrow_forward
Answer in Excel, Attached it question.
arrow_forward
Subject: acounting
arrow_forward
Net Present Value Method, Present Value Index, and Analysis for a service company
Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows:
MaintenanceEquipment
RampFacilities
ComputerNetwork
Amount to be invested
$591,053
$351,873
$159,991
Annual net cash flows:
Year 1
251,000
171,000
103,000
Year 2
233,000
154,000
71,000
Year 3
213,000
137,000
52,000
Present Value of $1 at Compound Interest
Year
6%
10%
12%
15%
20%
1
0.943
0.909
0.893
0.870
0.833
2
0.890
0.826
0.797
0.756
0.694
3
0.840
0.751
0.712
0.658
0.579
4
0.792
0.683
0.636
0.572
0.482
5
0.747
0.621
0.567
0.497
0.402
6
0.705
0.564
0.507
0.432
0.335
7
0.665
0.513
0.452
0.376
0.279
8
0.627
0.467
0.404
0.327
0.233
9
0.592
0.424
0.361
0.284
0.194
10
0.558
0.386
0.322
0.247
0.162
Required:
1. Assuming that the desired rate…
arrow_forward
Financial accounting
arrow_forward
Please find attached question
arrow_forward
Part D: Investment Decisions
Now consider that Luxio has identified the following two mutually exclusive projects:
Year
0
1
2
3
4
Cash Flow (A)
-$34,000
$16,500
$14,000
$10,000
$6,000
Cash Flow (B)
-$34,000
$5,000
$10,000
$18,000
$19,000.
1. What is the IRR for each of these projects? Based on IRR decision rule, which
project should the company accept?
2. If the required return is 11%, what is the NPV for each of these projects?
Based on the NPV decision rule, which project should the company accept?
3. Over what range of discount rates would the company choose project A? At
what discount rate would the company be indifferent between these two
projects? Explain.
arrow_forward
Ranking Investment Proposals: Payback Period, Accounting Rate of Return, and Net Present Value
Presented is information pertaining to the cash flows of three mutually exclusive investment proposals:
Proposal X Proposal Y Proposal Z
$92,000 $92,000 $92,000
Initial investment
Cash flow from operations
Year 1
Year 2
Year 3
Disinvestment
Life (years)
90,000
2,000
47,500
0
3 years
46,000
46,000
47,500
0
3 years
92,000
0
1 year
Select the best investment proposal using the payback period, the accounting rate of return on initial investment, and the net present value criteria. Assume that the organization's cost of capital is 14 percent.
Note: Follow rounding instructions noted for each computation. Use a negative sign with your answers, when appropriate.
Proposal Z Best proposal
0 x Z
0✔ X,Y
0 X X
Payback period (years)
Accounting rate of return; Round answers to 4 decimal places.
Net present value; Round answers to nearest whole number.
Proposal X
0 x
0 x
0 x
Proposal Y
0 x
0 x
0 x
◆
◆
◆
✓
arrow_forward
Consider the following investment projects.Year (n) Net Cash FlowProject 1 Project 20 -$1,200 -$2,0001 600 1,5002 1,000 1,000IRR 19.65% 17.54%Determine the range of MARR where project 2 would be preferred over project 1.(a) MARR … 12.5%(b) 13% … MARR … 15%(c) 16% … MARR(d) Not enough information to determine
arrow_forward
Ranking Investment Proposals: Payback Period, Accounting Rate of Return, and Net Present Value
Presented is information pertaining to the cash flows of three mutually exclusive investment proposals:
Proposal Proposal Proposal
Initial investment
Cash flow from operations
Year 1
x
Y
Z
$92,000 $92,000 $92,000
Year 2
Year 3
Disinvestment
Life (years)
90,000 46,000 92,000
2,000
46,000
47,500
47,500
0
0
0
3 years 3 years
1 year
Select the best investment proposal using the payback period, the accounting rate of return on initial investment, and the net present
value criteria. Assume that the organization's cost of capital is 14 percent.
Note: Follow rounding instructions noted for each computation. Use a negative sign with your answers, when appropriate.
Proposal X
Proposal Y
Proposal Z Best proposal
Payback period (years)
Accounting rate of return; Round answers to 4 decimal places.
Net present value; Round answers to nearest whole number.
2 ▾
17.2098 x
2▾
1 ▾ Z
÷
20,547 ✔
17.2098 x
15,808…
arrow_forward
Compute the PI statistic for Project Z if the appropriate cost of capital is 6 percent. Project Z Cash flow: –$3,300 $730 $860 $1,030 $680 $480
arrow_forward
Net Present Value Method, Present Value Index, and Analysis for a service company
Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows:
MaintenanceEquipment
RampFacilities
ComputerNetwork
Amount to be invested
$909,173
$541,268
$278,555
Annual net cash flows:
Year 1
405,000
284,000
178,000
Year 2
377,000
256,000
123,000
Year 3
344,000
227,000
89,000
Present Value of $1 at Compound Interest
Year
6%
10%
12%
15%
20%
1
0.943
0.909
0.893
0.870
0.833
2
0.890
0.826
0.797
0.756
0.694
3
0.840
0.751
0.712
0.658
0.579
4
0.792
0.683
0.636
0.572
0.482
5
0.747
0.621
0.567
0.497
0.402
6
0.705
0.564
0.507
0.432
0.335
7
0.665
0.513
0.452
0.376
0.279
8
0.627
0.467
0.404
0.327
0.233
9
0.592
0.424
0.361
0.284
0.194
10
0.558
0.386
0.322
0.247
0.162
Required:
1. Assuming that the desired…
arrow_forward
Answer with formulas for upvotes?
arrow_forward
You are given the following financial information related to a capital investment project. What is the project's Year 1 Net Cash Flow?
Sales revenues
Depreciation
Other operating costs
Interest Exp
Tax rate
WACC
Select one:
a. $8,580
b. $8,900
c. $9,350
d. $9,463
e. $9,832
$22,250
$8,000
$12,000
$800
40.0%
12.0%
arrow_forward
Manji
arrow_forward
Clearcast Communications Inc. is considering allocating a limited amount of capital investment
funds among four proposals. The amount of proposed investment, estimated operating income,
and net cash flow for each proposal are as follows:
Operating
Income
Net Cash
Flow
Investment
Year
Proposal A:
$450,000
$ 30,000
1
$120,000
2
30,000
120,000
3
20,000
110,000
4
10,000
100,000
(30,000)
$ 60,000
$ 60,000
40,000
60,000
$510,000
$100,000
Proposal B:
$200,000
1
80,000
3
20,000
60,000
4
(10,000)
30,000
(20.000)
$ 90,000
20.000
$290,000
(Continued)
arrow_forward
Use Table 8 to answer the next two questions. Assume the committed capital is $100,
the management fee is 2.00%, and the carried interest is 20.00%.
Year
2015
2016
2017
2018
2019
$5.40
What is the carried interest in 2019?
Called-down Paid in capital Mgmt Fees
$26
$31
$21
O $11.20
$9.12
$9.85
$10
$12
Table 8
Operating NAV before Carried
NAV after
Results Distributions Interest Distributions Distributions
-$14
$6
$11
$41
$46
$5
$10
arrow_forward
Discount Rate
12%
Investment Project
Cash Flow
Total Net Cash Flow
Initial Investment
$ (8,000)
?
Year 1
$ 800
?
Year 2
$ 900
?
Year 3
$ 1,500
?
Year 4
$ 1,800
?
Year 5
$ 3,200
NPV of investment
$ ?
Estimated Payback Period
?
Estimate the total net cash flows, NPV of Investment and Estimated Payback Period using the excel's formula.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Related Questions
- Year Investment A 2016 $400.000 2017 $400.000 2018 $400.000 2019 $400.000 2020 $400.000 Investment B $100.000 $100.000 $100.000 $1.000.000 $1.000.000 calculate the Npv of both projectarrow_forwardhsd.1arrow_forward1. Consider the following investment projects: Year(n) Net cash flow Project 1 -$1,200 Project 2 -$2,000 1 600 1,500 2 1,000 1,500 IRR 19.65% 17.53% Determine the range of MARR for which Project 2 would be preferred over Project 1arrow_forward
- Net Present Value Method, Present Value Index, and Analysis First United Bank Inc. is evaluating three capital investment projects using the net present value method. Relevant data related to the projects are summarized as follows: BranchOfficeExpansion ComputerSystemUpgrade ATMKioskExpansion Amount to be invested $787,317 $584,976 $298,035 Annual net cash flows: Year 1 391,000 278,000 164,000 Year 2 364,000 250,000 113,000 Year 3 332,000 222,000 82,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5 0.747 0.621 0.567 0.497 0.402 6 0.705 0.564 0.507 0.432 0.335 7 0.665 0.513 0.452 0.376 0.279 8 0.627 0.467 0.404 0.327 0.233 9 0.592 0.424 0.361 0.284 0.194 10 0.558 0.386 0.322 0.247 0.162 Required: 1. Assuming that the desired rate of return is 10%,…arrow_forwardComplete the tablearrow_forwardAnswer in Excel, Attached it question.arrow_forward
- Subject: acountingarrow_forwardNet Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: MaintenanceEquipment RampFacilities ComputerNetwork Amount to be invested $591,053 $351,873 $159,991 Annual net cash flows: Year 1 251,000 171,000 103,000 Year 2 233,000 154,000 71,000 Year 3 213,000 137,000 52,000 Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5 0.747 0.621 0.567 0.497 0.402 6 0.705 0.564 0.507 0.432 0.335 7 0.665 0.513 0.452 0.376 0.279 8 0.627 0.467 0.404 0.327 0.233 9 0.592 0.424 0.361 0.284 0.194 10 0.558 0.386 0.322 0.247 0.162 Required: 1. Assuming that the desired rate…arrow_forwardFinancial accountingarrow_forward
- Please find attached questionarrow_forwardPart D: Investment Decisions Now consider that Luxio has identified the following two mutually exclusive projects: Year 0 1 2 3 4 Cash Flow (A) -$34,000 $16,500 $14,000 $10,000 $6,000 Cash Flow (B) -$34,000 $5,000 $10,000 $18,000 $19,000. 1. What is the IRR for each of these projects? Based on IRR decision rule, which project should the company accept? 2. If the required return is 11%, what is the NPV for each of these projects? Based on the NPV decision rule, which project should the company accept? 3. Over what range of discount rates would the company choose project A? At what discount rate would the company be indifferent between these two projects? Explain.arrow_forwardRanking Investment Proposals: Payback Period, Accounting Rate of Return, and Net Present Value Presented is information pertaining to the cash flows of three mutually exclusive investment proposals: Proposal X Proposal Y Proposal Z $92,000 $92,000 $92,000 Initial investment Cash flow from operations Year 1 Year 2 Year 3 Disinvestment Life (years) 90,000 2,000 47,500 0 3 years 46,000 46,000 47,500 0 3 years 92,000 0 1 year Select the best investment proposal using the payback period, the accounting rate of return on initial investment, and the net present value criteria. Assume that the organization's cost of capital is 14 percent. Note: Follow rounding instructions noted for each computation. Use a negative sign with your answers, when appropriate. Proposal Z Best proposal 0 x Z 0✔ X,Y 0 X X Payback period (years) Accounting rate of return; Round answers to 4 decimal places. Net present value; Round answers to nearest whole number. Proposal X 0 x 0 x 0 x Proposal Y 0 x 0 x 0 x ◆ ◆ ◆ ✓arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning