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
Complete the table
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
i need this question answer General accounting
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
The following table contains information about four projects in which Morales Corporation has the opportunity to invest. This
information is based on estimates that different managers have prepared about their potential project.
E (Click the icon to view the projects information.)
Requirements
1. Rank the four projects in order of preference by using the
a. net present value.
d. payback period.
2. Which method(s) do you think is best for evaluating capital investment projects in general? Why?
c. internal rate of return.
b. project profitability index.
e. accounting rate of return.
Requirement 1. Rank the projects in order of preference.
(a)
(b)
(c)
(d)
(e)
Net Present
Profitability
Internal Rate
Payback
Accounting Rate
Value
Index
of Return
Period
of Return
1st preferred
A
C
2nd preferred
3rd preferred
C
4th preferred
ADB
D AB
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 A Proposal B Proposal C
$ 45,000
$ 45,000
$ 45,000
Initial investment
Cash flow from operations
Year 1
Year 2
Year 3
Disinvestment
Life (years)
40,000
5,000
22,500
22,500
22,500
22,500
0
0
3 years 3 years
45,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 12 percent..
Note: Follow rounding instructions noted for each computation. Use a negative sign with your answers, when appropriate.
Proposal A
Proposal B Proposal C Best proposal
Payback period (years)
Accounting rate of return; Round answers to 4 decimal places.
Net present value: Round answers to nearest whole number. S
arrow_forward
The following table tracks the main components of working capital over the life of a four-year project.
2021
2022
2023
2024
2025
Accounts receivable
0
174,000
249,000
214,000
0
Inventory
87,000
142,000
142,000
107,000
0
Accounts payable
31,000
56,000
62,000
41,000
0
Calculate net working capital and the cash inflows and outflows due to investment in working capital.
arrow_forward
You are given the following data for a project that is to be evaluated using the APV method.
Year
EBIT
CAPEX
0
O $201.765
O $193,822
O $185,617
O $222,872
O $213,918
1
$127.000
$60,000
2
Depreciation
Increase in NWC
Year-end net debt $80,000
Cost of net debt = 8%
Unlevered cost of capital = 11.8%
Corporate tax rate = 30%
Calculate the total value of the project at t = 0. using the APV method.
$72,000
$50,000
$100,000
$133,000
$40,000
$80,000
$60,000
$140,000
3
$138.500
$10,000
$84,000
$30,000
$140,000
arrow_forward
Vishu
arrow_forward
Solve this general accounting question
arrow_forward
Year
Project 1
Net Cash Flows
Project 2
Initial investment
$(60,000)
$(55,500)
1.
2.
15,000
35,000
27,400
3.
22,000
15,000
22,000
a. Compute payback period for each project. Based on payback period, which project is preferred?
b. Compute net present value for each project. Based on net present value, which project is preferred?
Complete this question by entering your answers in the tabs below.
Required A Required B
Compute net present value for each project. Based on net present value, which project is preferred?
Note: Round your present value factor to 4 decimals. Round your final answers to the nearest whole dollar.
Net Cash
Flows
Present Value
Present Value of Net
Factor
Cash Flows
Project 1
Year 1
Year 2
Year 3
Totals
Initial investment
Net present value
Project 2
Year 1
Year 2
Year 3
Totals
Initial investment
$
0
$
0
$
0
$
0
$
0
Net present value
Based on net present value, which project is preferred?
$
0
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
- Complete the tablearrow_forwardSubject: 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_forward
- Financial accountingarrow_forwardPlease 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_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_forwardi need this question answer General accountingarrow_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 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
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