Template-Assignment 2(2)
xlsx
keyboard_arrow_up
School
University of Technology Sydney *
*We aren’t endorsed by this school
Course
48260
Subject
Finance
Date
Apr 3, 2024
Type
xlsx
Pages
44
Uploaded by DoctorMetalElk31
Group Number: Student ID- Name
13197140 - Dean Thill
24866600 - Chenfeng Ma
24866586 - Ruihan Gao
24901872 - Mutian Shangguan
24901819 - Botu Li
Topic of th
Allocated task for data collection
Identify the main projects, search for literature and relevant financial analysis information.Provide Mirvac Property Trust FY23 Annual Repri and related information.Search for relevant financial information and fill in the Alternative A&B.
Organize company project information and write a project analysis for alternative project B.Collect data related to assets and liabilities.Search and integrate relevant information from government documents.
Organize company project information, collect news and official information.Collect data related to assets and liabilities.Search and integrate relevant information from government documents.Fill in Part B of the alternative plan for the hypothesis table.
Organize company project information and write a project analysis for alternative project A. Write task allocation tables for inventory related data.Search and integrate relevant information from government documents.Fill out the project information form.
Organize company project information and write project analysis for major projects.Collect data related to stocks.Search and integrate relevant information from government documents.Fill out the Alternative Option A section of the Assumption Form.
he project
Allocated task for calculation or settin the CBA and assumption tables
Calculate the CBA table for Alternative B.
Calculate and write Indicators table.
Calculate and write Indicators table.
Calculate the CBA table for Alternative A.Calculate and explain Financial Evaluation.
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
Student Name
General information
Name of company
Short description of the company
Data requirement (You might need to add more information)
Student Name
Total debt
Total assets
Current assets
Current liabilities
Sales
Net income
Student Name
Average equity Price per share
Earnings per share
Indicators
Student Name
Debt Ratio
Current Ratio
The purpose of this sheet is to provide information about the company that owns the project
Total Assets Turnover
Return on Equity
Price-to-Earnings Ratio
13197140 - Dean Thill
Explanation
Mirvac Group
Value
24901872 - Mutian Shangguan
$2763m
$11753m
$838m
$487m
$890m
$340m
24901819 - Botu Li
$1973.3 m
$2.36 $0.16 What data are included in this calculation 24866586 - Ruihan Gao
Debt Ratio = Total Debt / Total Assets
Current Ratio = Current Assets / Current Liabilities
Mirvac is a property development group which focuses on both small and large projects. It is one of the larger property developers in the market.
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
Total Assets Turnover = Sales / Total Assets
ROE = Net Income / Fair share capital
P/E Ratio = Price per Share / Earnings per Share23
MIRVAC PROPERTY TRUST p.10
MIRVAC PROPERTY TRUST p.10
MIRVAC PROPERTY TRUST p.10
MIRVAC PROPERTY TRUST p.10
MIRVAC PROPERTY TRUST p.10
MIRVAC PROPERTY TRUST p.10
MIRVAC PROPERTY TRUST p.10
MIRVAC PROPERTY TRUST p.33
MIRVAC PROPERTY TRUST p.33
Values
23.50%
172%
Source of data (Provide us with page number if you used the financial statements of the company)
7.60%
17.20%
23.6
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
Interpretation of results
A debt ratio of 0.23, typically expressed as 23%, indicates that a company has a moderate level of debt relative to its total assets.
A current ratio of 1.72, typically expressed as 172%, suggests that the company has a healthy level of liquidity and is well-positioned to meet its short-term financial obligations.
A Total Assets Turnover of 7.6% is a bit low, it suggests that the company may not be efficiently using its assets to generate revenue.
An ROE of 17.2% is generally considered a positive sign, indicating that the company is generating a healthy return for its shareholders.
A P/E ratio of 23.6 suggests that the stock is trading at a multiple of 23.6 times its earnings, reflecting investor expectations and sentiment.
Student Name
Title of the project
Project Description
Alternative A
This sheet is about your project
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
Alternative B
13197140 - Dean Thill
Harbourside revitalisation project
The project is the revitalisation of the Harbourside shopping centre which is a project run by t
development group which focuses on both small and large projects. It is one of the larger prop
posted a 1.11 billion dollar total revenue and other income. In 2023 it posted a 742 million do
downturn was from the revaluation loss on its investment properties and nominal increases in
by external causes. As a property developer most of its capital lies in its property assets and involves demolishing the former harbourside shopping centre and redeveloping it into a comm
was built in the 1990s and by the late 2010s was struggling to attract a large amount of foot customers) suffered. Thus, the project serves as a service/quality improvement for these stor
on the site, it will also encourage the residents to conduct most of their shopping within the c
well as providing an additional source of income for Mirvac from rent.This project is relevant a
Harbourside sits on the waterfront of Darling Harbour, a very public area of the CBD. It is on
such a prominent site as well, the building will also form a prominent part of the cityscape, th
project, it will be remembered. It should also be noted that when finished the project will aff
successful, the local economy will be helped significantly. If unsuccessful, the local economy
Mirvac Group plans to conduct a comprehensive renovation of the seaside shopping center to
shopping center is located in the coastal area, and its value has gradually declined due to its redevelopment, Mirvac Group believes that continuing refurbishment would be a more cost-e
pointed out that the current Binhai Shopping Center is outdated, considered a "tired travel tra
that shopping centers need to reposition themselves to meet the needs of modern consumers
has developed the following plan:
Modern facilities: The shopping center will undergo a comprehensive facility upgrade, includin
store, improving the comfort of the shopping environment, and improving parking facilities an
customers with a more enjoyable shopping experience.
Solar panels: In order to reduce operating costs and reduce environmental impact, Mirvac Gro
shopping centers. This will help provide green energy, reduce electricity consumption, and pr
Business strategy reshaping: Mirvac Group will reassess the business strategy of shopping ce
to attract a wider customer base. They will also seek to provide diverse entertainment and din
a hub for social and cultural activities.
Improving sustainability: In addition to solar panels, shopping centers will also adopt other su
management and water-saving schemes, to reduce environmental footprint.
Through these measures, Mirvac Group hopes to improve the image of shopping centers, enh
maintain the value of their investment portfolio, and ensure that they continue to remain com
focuses on business success, but also on sustainability and environmental responsibility.
Mirvac Group plans to conduct a comprehensive reconstruction of the seaside shopping cente
commercial office project. Based on feedback from week five, we assume that Company B wil
develop it into an office/residential space. The project intention behind Mirvac Group is to reb
and provide independent office/residential space. The geographical location of the seaside sh
advantageous location. The factors contributing to this situation include its seaside location, p
(ferries, light rail, buses, and trains), and location very close to the Central Business District. C
and its development towards online shopping, Mirvac's investment in redeveloping this space
pointless. Redeveloping it as a dedicated residential space or renting office space would be m
This will provide greater flexibility for Mirvac's venue. Specifically, Mirvac's plan includes the f
Residential space: The shopping center will be redesigned as a low to mid story building, prov
will benefit from their unique geographical location, enjoying magnificent seaside scenery and
Commercial office space: Some shopping centers will be converted into modern commercial o
needs. These spaces will attract companies to seek highly accessible and visible geographica
Flexibility and Sustainability: Mirvac will ensure that the project has flexibility to adapt to mar
adopting green buildings and energy-saving measures to reduce environmental impacts.
By transforming shopping centers into residential and commercial office projects, Mirvac aims
geographical location, diversify its investment portfolio, and ensure competitiveness in the co
plan emphasizes Mirvac's strategic vision and adaptability to future market trends.
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
The following template is an indicative one, and it can
Student Name
24901819 - Botu Li
Assumptions- Alternative A
Values
Capital Cost
$137,092,307.69 Operating cost
$20 million - $35 million annually
Maintanace cost
$20 million - $35 million annually
Benefits
$55.6million - $86.7million per year
Salvage value
$79,357,259.69 Discount rate
5.47%
This sheet is about assumptions that you will use for the CBA analysis (Provide the detail) for both Alternatives
Project life
75 years
Student Name
24866586 - Ruihan Gao
Values
Capital Cost
$2 billion
Operating cost
$20 million - $40 million annually
Maintanace cost
$20 million - $40 million annually
Benefits
Salvage value
Discount rate
8%
Project life
50years
Assumptions- Alternative B
$62.22 million to $82.72 million annually
$400 million (This is a very rough estimate as property values could appreciate).
n be modified as needed
What elements are included in this calculation
Annual maintenance costs, operating costs, and all revenue for that year.
The annual fixed cost plus all the debt. And all income plus current assets each year.
The cost of land acquisition includes the cost of purchasing and clearing existing land, as well
potential land taxes and licensing fees that may need to be paid. The cost of building develop
includes the construction costs of buildings, infrastructure, and public spaces, including desig
construction, decoration, and equipment. Financing costs include loan interest, financing expe
loan handling fees, etc.
The various taxes and wages required for the operation of shopping centers include a series o
infrastructure costs such as water, electricity and gas required for construction.
Maintenance costs include fixed annual payments for utilities and gas. There is also the main
cost of the annual renovation of the mall's equipment.
All the capital invested in the initial phase of the project, the capital that the project needs to
each year after the initial investment.
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
What elements are included in this calculation
refurbishment, equipment replacements, and infrastructure upkeep
this is a large real estate development, its value might appreciate over time rather than depr
The life of the building materials, the service life and the local land environment limit the size
shopping mall.
The text mentions a "$2 billion revitalization project" for the Harbourside mixed-use precinct.
be considered the overall capital cost for the project.
utilities, salaries of employees, security, cleaning, landscaping, and other day-to-day operatio
precinct
1. Commercial Space(Assuming a rental rate for premium commercial space in Sydney (based
previous years' data until 2022), the price could be around AUD $800 to $1,200 per square m
annually) 2.Residential Space(265 luxury apartments, assuming we can sell 50 units in the fir
year,and we assume each apartment is sold for an average of AUD $2 million (a conservative
for luxury apartments in Sydney's prime locations).3.Retail Space(assuming a rental rate of A
$1,000 to $1,500 per square meter annually). 4.Public Domain Funding and Art Activation 5.P
Open Spaces
In real estate, a typical discount rate might range from 6-12%. However, given this is a signifi
urban project with government involvement, let's assume a modest discount rate.
The project life might be based on the expected lifespan of the buildings and infrastructure. L
mixed-use developments are often designed to last several decades.
Source of dataset
¥15,102,469.62 2000000000.00 25000000.00 35000000.00 80000000.00 400000000.00 https://www.urban.com.au/news/nsw/harboursi
https://www.urban.com.au/news/nsw/harboursi
https://www.ipcn.nsw.gov.au/cases/2021/04/ha
https://www.urban.com.au/news/nsw/harboursi
https://www.urban.com.au/news/nsw/harboursi
https://www.ipcn.nsw.gov.au/cases/2021/04/ha
Source of dataset
https://www.ipcn.nsw.gov.au/cases/2021/04/
harbourside-shopping-centre--darling-harbour & https://www.planningportal.nsw.gov.au/major-
projects/projects/harbourside-shopping-
centre-redevelopment
https://www.mirvac.com/en/about/news-and-m
These details haven't been provided, but we can make a rough assumption. For a large-
scale mixed-use precinct, annual operating costs could be in the ballpark of 1-3% of the capital cost.
Also no details ,assuming 1-2% of the capital cost annually might be reasonable.
REA Group (realestate.com.au) JLL Australia (jll.com.au) CBRE Australia (cbre.com.au) Reserve Bank of Australia (rba.gov.au)
https://www.investopedia.com/terms/s/salvage
https://www.investopedia.com/ https://www.wbdg.org/resources/life-cycle-asse
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
-64897530.38
-44897530.38
-24897530.38
¥20,000,000.00 (¥64,897,530.38)
(¥44,897,530.38)
(¥24,897,530.38)
¥95,102,469.62 ¥75,102,469.62 ¥55,102,469.62
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
-4897530.38
35102469.62
55102469.62
75102469.62
(¥4,897,530.38)
¥35,102,469.62 ¥55,102,469.62 ¥75,102,469.62 ¥35,102,469.62 (¥4,897,530.38)
(¥24,897,530.38)
(¥44,897,530.38)
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
95102469.62
¥95,102,469.62 (¥64,897,530.38)
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
Student Name
CBA- Ailternative A
Year
Income statement
+Revenue
-manufacturing and O&M cost
-Depreciation
-Debt interest
Taxable income
-Income tax
Net income
Cash flow statement
Operating activities
+Net income
+Depreciation
Investing activities
-Capital investment
+Salvage value
-Gains tax
+Losses (on Depreciable Assets)
-investment in working Capital
Working capital recovery
-Repayment of principal
Net cash flow
Student Name
Financial Evaluation
PB
NPV
BCR
This sheet is about the cash-flow and the calculation of the financial indicators for both Alternatives
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
Student Name
CBA- Ailternative B
Year
Income statement
+Revenue
-manufacturing and O&M cost
-Depreciation
-Debt interest
Taxable income
-Income tax
Net income
Cash flow statement
Operating activities
Financing activities
+Borrowed Funds
-Repayment of principal
Net cash flow
Student Name
Financial Evaluation
PB
NPV
BCR
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
24901872 - Mutian Shangguan
method of calculation
$Manufacturing\ and\ O&M\ Cost$
$Depreciation = \frac{Capital\ Cost}{Project\ Life}$
$Debt\ Interest = Capital\ Cost \times Discount\ Rate$
$Taxable\ Income = Revenue - (Manufacturing\ and\ O&M\ Cost + Depreciation + Debt\ Int
$Income\ Tax = Taxable\ Income \times Tax\ Rate$
$Net\ Income = Taxable\ Income - Income\ Tax$
Obtained from Income Statement
$Capital\ Investment = Capital\ Cost$
$Salvage\ Value$
$Gains\ Tax = \frac{(Capital\ Investment - Salvage\ Value)}{Project\ Life}$
$Losses = Depreciation$
Annual capital recovery amount=(investment cost residual value)/project life
Assuming that 10% of the borrowed funds need to be repaid annually as principal repayme
24901872 - Mutian Shangguan
Interpretation of results
PB value is used to measure the profitability of a project. If PB is greater than 1, the projec
economic benefits because a positive NPV indicates a positive net present value of the pro
project may not have sufficient profitability, indicating that the net present value of the pro
NPV is an important indicator for evaluating whether a project's investment is worth it. If th
project is financially profitable; if the NPV is negative, the project may not have profitability
indicates a more attractive investment.
BCR is used to evaluate the relationship between the benefits and costs of a project. If the
total return of the project is greater than the total cost, which is usually considered a good
less than 1, the project may not be worth investing because the total cost is greater than t
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
24866600 - Chenfeng Ma
method of calculation
$Manufacturing\ and\ O&M\ Cost$
$Depreciation = \frac{Capital\ Cost}{Project\ Life}$
$Debt\ Interest = Capital\ Cost \times Discount\ Rate$
$Taxable\ Income = Revenue - (Manufacturing\ and\ O&M\ Cost + Depreciation + Debt\ Int
$Income\ Tax = Taxable\ Income \times Tax\ Rate$
$Net\ Income = Taxable\ Income - Income\ Tax$
Assuming that 10% of the borrowed funds need to be repaid annually as principal repayme
24901872 - Mutian Shangguan
Interpretation of results
The operating cost involves the cost from the beginning of reconstruction to ope
the pre-sale of buildings before completion. The specific operating costs are dete
subsequent owners.
PB value is used to measure the profitability of a project. If PB is greater than 1, the projec
economic benefits because a positive NPV indicates a positive net present value of the pro
project may not have sufficient profitability, indicating that the net present value of the pro
NPV is an important indicator for evaluating whether a project's investment is worth it. If th
project is financially profitable; if the NPV is negative, the project may not have profitability
indicates a more attractive investment.
BCR is used to evaluate the relationship between the benefits and costs of a project. If the
total return of the project is greater than the total cost, which is usually considered a good
less than 1, the project may not be worth investing because the total cost is greater than t
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
1
2
3
$35.6 million
$46.15 million
$35.7 million
$20 million
$27.5 million
$21 million
$1,827,899.44 $1,827,899.44 $1,827,900.44 $7,504,156.54 $7,504,156.54 $7,504,156.54 $14,192,180.22 $18,982,148.82 $18,982,148.82 $4,257,654.07 $5,694,644.65 $5,694,644.65 $4,257,654.07 $5,694,644.65 $4,232,121.14 $4,257,654
$5,694,645
$4,232,121
$1,827,899.44 $1,827,899.44 $1,827,899.44 $137,092,308
$137,092,308
$137,092,308
$79,357,260
$79,357,260
$79,357,260
$57,735,048
$57,735,048
$57,735,048
$1,827,897.43 $1,827,897.43 $1,827,897.43 $12,511,291
$12,511,291
$7,573,299
$4,937,992
$5,950,000
$7,573,299
$128,053.82 &137,092.31
$146,232
$5,242,430.12 $6,694,004.82 $7,303,682.35 $57,735,048
Values
1.0467
$6,423,773.49 0.1249
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
1
2
3
$62.22 million
$72.47 million $82.72 million $20 million
$30 million
$40 million $40 million
$40 million
$40 million
$13709.230.77
$13,709,231 $13.709.230.77
$8,509,769.23 $11,239,230.77 $11,989,230.77 $3,596,769.23 $1,886,769.23 $3,596,769.23 $8,392,461.54 $4,402,461.54 $8,392,461.54 $20 million
$30 million
$40 million $40,000,000.00 $40,000,000.00 $40,000,000.00 $7,504,156.54 $7,504,156.54 $7,504,157 $5,284,156.54 $5,034,156.54 $4,784,156.54 Values
0.0045
$15,102,469.62 2.4167
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
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
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
NPV
-20%
Capital Cost
$ 33,842,234.9 Operating cost
$ 12,423,773.3 Maintanace cost
$ 11,423,773.2 Benefits
$ (9,576,226.5)
Salvage value
$ (9,447,678.3)
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
NPV
-20%
Capital Cost
$ 415,102,469.6 Operating cost
$ 20,102,469.6 Maintanace cost
$ 22,102,469.6 Benefits
$ (897,530.4)
Salvage value
$ (64,897,530.4)
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
Sensivity analysis results
-15%
-10%
-5%
0%
$ 26,987,619.9 $ 20,133,004.1 $ 13,278,388.8 $ 6,423,773.5 $ 10,923,773.0 $ 9,723,773.3 $ 7,923,773.5 $ 6,423,773.5 $ 10,173,773.3 $ 8,923,773.8 $ 7,673,773.2 $ 6,423,773.5 $ (5,576,226.5)
$ (1,576,226.5) $ 2,423,773.5 $ 6,423,773.5 $ (5,479,815.4)
$ (1,511,952.4) $ 2,455,910.5 $ 6,423,773.5
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
Sensivity analysis results
-15%
-10%
-5%
0%
$ 315,102,469.6 $ 215,102,469.6 $ 115,102,469.6 $ 15,102,469.6 $ 18,852,469.6 $ 17,602,469.6 $ 16,352,469.6 $ 15,102,469.6 $ 20,352,469.6 $ 18,602,469.6 $ 16,852,469.6 $ 16,852,469.6 $ 3,102,469.6 $ 7,102,469.6 $ 11,102,469.6 $ 15,102,469.6 $ (44,897,530.4)
$ (24,897,530.4)
$ (4,897,530.4) $ 15,102,469.6
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
5%
10%
15%
20%
$ (430,841.8) $ (7,285,457.2) $ (14,140,072.8) $ (20,994,687.1)
$ 4,923,773.4 $ 3,423,773.4 $ 1,923,773.7 $ 423,773.7 $ 5,173,773.7 $ 3,923,773.9 $ 2,673,773.6 $ 1,423,773.4 $ 10,423,773.5 $ 14,423,773.5 $ 18,423,773.5 $ 22,423,773.5 $ 10,391,636.4 $ 14,359,499.4 $ 18,327,362.3 $ 22,295,225.3
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
5%
10%
15%
20%
$ (84,897,530.4) $ (184,897,530.4) $ (284,897,530.4) $ (384,897,530.4)
$ 13,852,469.6 $ 12,602,469.6 $ 11,352,469.6 $ 10,102,469.6 $ 13,352,469.6 $ 11,602,469.6 $ 9,852,469.6 $ 8,102,469.6 $ 19,102,469.6 $ 23,102,469.6 $ 27,102,469.6 $ 31,102,469.6 $ 35,102,469.6 $ 55,102,469.6 $ 75,102,469.6 $ 95,102,469.6
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
-20%
-15%
-10%
$(20,000,000.0)
$(10,000,000.0)
$- $10,000,000.0 $20,000,000.0 $30,000,000.0 $40,000,000.0 NPV($000)
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
$(30,000,000.0)
Capital Cost
Opera
-20%
-15%
$(500,000,000.0)
$(400,000,000.0)
$(300,000,000.0)
$(200,000,000.0)
$(100,000,000.0)
$- $100,000,000.0 $200,000,000.0 $300,000,000.0 $400,000,000.0 $500,000,000.0 Ca
NPV($000)
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
-5%
0%
5%
10%
15%
Sensivity Analysis
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
ating cost
Maintanace cost
Benefits
Salvage value
Deviation
-10%
-5%
0%
5%
10%
Sensivity Analysis
pital Cost
Operating cost
Maintanace cost
Benefits
Salvage value
Deviation
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
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
15%
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
Related Documents
Related Questions
Required information
Exercise 6-4 and Exercise 6-5 (Algo)
[The following information applies to the questions displayed below.]
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of
its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Accounts payable
Accounts receivable
Accrued interest payable
Accumulated depreciation
Administrative and selling expenses
Allowance for uncollectible accounts
Capital assets
Cash
Charges for sales and services
Cost of sales and services
Depreciation expense
Due from General Fund
Interest expense
Interest revenue
Transfer in from General Fund
Bank note payable
Supplies inventory
Totals
Exercise 6-4 (Algo)
$
Debits
31,900
55,500
732,000
99,500
509,000
53,500
18, 200
41,400
Credits
$ 117,000
35,100
53,500
13,900
579,000
6,200
128,500
628,500
20,700
$1,561,700 $1,561,700
Required:
a. Prepare the closing entries for December 31.
b. Prepare…
arrow_forward
For each of the following transactions, determine the correct debit account from among the choices below:
A. Expenditures
B. Encumbrances
C. Property, Plant, and Equipment (Capital Assets)
D. Expenses
E. Appropriations
F. Other Financing Uses-Transfers Out
G. Extraordinary Item
H. Special Items
I. Liabilities
J. Answer not included in the above selections
A proprietary fund signs a contract to build an office building with Do Good Construction for $10,000,000
Answer 1 Question 3
A proprietary fund makes a currently due principal payment on Bonds Payable
Answer 2 Question 3
A proprietary fund recognizes and pays an interest payment that is currently due
Answer 3 Question 3
A proprietary fund spends $5,000,000 of a capital grant for construction of a parking garage. Assume eligibility has been met
Answer 4 Question 3
A city’s water supply in a proprietary fund is contaminated by terrorists. Cost of clean up, disposal and…
arrow_forward
https://portal.laserfiche.com/Portal/DocView.aspx?id=638006&repo=r-49e9e584
1. Who is the CPA firm that audited Jefferson City, Missouri in October 31, 2022?2. The type of audit opinion given Jefferson City, Missouri at October 31, 2022?3. What 3 categories of funds does Jefferson City have?4. Which program in Jefferson City has the largest expenses?5. What is the largest source of revenue in Jefferson City for governmental activities?6. What was the October 31, 2022 net position of the airport fund?7. In the October 31, 2022 Statement of Activities how many years of financial information is presented?8. Does Jefferson City have any discretely presented component units? What are they?9. What entities were excluded from Jefferson Cities financial reports?10. Does Jefferson City include Cash Equivalents with its Cash balance?11. What is the threshold amount for capitalizing an asset for depreciation purposes?12. Over what amount of years are traffic lights depreciated?13. List one…
arrow_forward
Foc
arrow_forward
Subject : Accounting
arrow_forward
Visno
arrow_forward
Required information
[The following information applies to the questions displayed below.]
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of
its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Accounts payable
Accounts receivable
Accrued interest payable
Accumulated depreciation
Administrative and selling expenses
Allowance for uncollectible accounts
Capital assets
Cash
Charges for sales and services
Cost of sales and services
Depreciation expense
Due from General Fund
Interest expense
Interest revenue
Transfer in from General Fund
Bank note payable
Supplies inventory
Totals
Debits
Adjustments:
$ 29,400
53,000
VILLAGE OF SEASIDE PINES
ENTERPRISE FUND
Reconciliation of Operating Income to
Net Cash Provided by Operating Activities
For the year ended December 31, 2024
722,000
98,000
504,000
51,000
17,700
40,900
19,700
$ 1,535,700
Credits
$ 112,000
32,600
51,000…
arrow_forward
3
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Debits
Credits
Accounts payable
$ 108,000
Accounts receivable
$ 27,400
Accrued interest payable
30,600
Accumulated depreciation
49,000
Administrative and selling expenses
51,000
Allowance for uncollectible accounts
13,000
Capital assets
714,000
Cash
96,800
Charges for sales and services
561,000
Cost of sales and services
500,000
Depreciation expense
49,000
Due from General Fund
17,300
Interest expense
40,500
Interest revenue
5,300
Transfer in from General Fund
117,600
Bank note payable
630,400
Supplies inventory
18,900
Totals
$ 1,514,900
$ 1,514,900
Required:
Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at…
arrow_forward
3
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Debits
Credits
Accounts payable
$ 108,000
Accounts receivable
$ 27,400
Accrued interest payable
30,600
Accumulated depreciation
49,000
Administrative and selling expenses
51,000
Allowance for uncollectible accounts
13,000
Capital assets
714,000
Cash
96,800
Charges for sales and services
561,000
Cost of sales and services
500,000
Depreciation expense
49,000
Due from General Fund
17,300
Interest expense
40,500
Interest revenue
5,300
Transfer in from General Fund
117,600
Bank note payable
630,400
Supplies inventory
18,900
Totals
$ 1,514,900
$ 1,514,900
Required:
Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at the…
arrow_forward
4.
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of its fiscal year. The enterprise fund was established this year
through a transfer from the General Fund.
Accounts payable
Accounts receivable
Accrued interest payable
Accumulated depreciation
Administrative and selling expenses
Allowance for uncollectible accounts
Capital assets
Cash
Charges for sales and services
Cost of sales and services
Depreciation expense
Due from General Fund
Interest expense
Interest revenue
Transfer in from General Fund
Bank note payable
Supplies inventory
Totals
Debits
$32,000
47,000
712,000
89,000
479,000
45,000
17,000
40,000
18,000
$1,479,000
Credits
$ 96,000
28,000
45,000
12,000
550,000
4,000
119,000
625,000
$1,479,000
Required:
a. Prepare the closing entries for December 31.
b. Prepare the Statement of Revenues, Expenses, and Changes in Fund Net Position for the year ended December 31.
c. Prepare the Net Position section of the…
arrow_forward
!
Required information
[The following information applies to the questions displayed below.]
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of
its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Accounts payable
Accounts receivable
Accrued interest payable
Accumulated depreciation
Administrative and selling expenses
Allowance for uncollectible accounts
Capital assets
Cash
Charges for sales and services
Cost of sales and services
Depreciation expense
Due from General Fund
Interest expense
Interest revenue
Transfer in from General Fund
Bank note payable
Supplies inventory
Totals
Required A
Required B
Complete this question by entering your answers in the tabs below.
Required C
VILLAGE OF SEASIDE PINES
ENTERPRISE FUND
Statement of Net Position
December 31, 2024
Net Position:
Net Investment in Capital Assets
Unrestricted
Total Net Position
Debits
Required:
a.…
arrow_forward
!
Required information
[The following information applies to the questions displayed below.]
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of
its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Accounts payable
Accounts receivable
Accrued interest payable
Accumulated depreciation
Administrative and selling expenses
Allowance for uncollectible accounts
Capital assets
Cash
Charges for sales and services
Cost of sales and services
Depreciation expense
Due from General Fund
Debits
$
Credits
96,000
$
32,000
28,000
45,000
47,000
12,000
712,000
89,000
550,000
479,000
45,000
17,000
Interest expense
Interest revenue
Transfer in from General Fund
Bank note payable
Supplies inventory
Totals
40,000
18,000
4,000
119,000
625,000
$1,479,000 $1,479,000
Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at the bottom of…
arrow_forward
Recording journal entries for nonprofits
Prepare journal entries to record the following transactions.
1. Donor A gave the nonprofit a cash gift of $50,000 in June 2019, telling the nonprofit the gift could not be used until 2020. (Identify the affected net asset classification(s) in the journal entries
made both in June 2019 and at the start of 2020.)
2. Attorney Howard Gorman volunteered his services to Taconic Singers, a nonprofit. He spent 12 hours preparing contracts for the services of professional singers and 8 hours serving as an usher before
performances. Gorman normally gets $200 an hour for legal services, and Taconic normally pays $8 an hour when it hires ushers.
3. Donor B sent a letter to a nonprofit, saying she would donate $20,000 in cash to the nonprofit, to be used for any purpose the nonprofit's trustees desired, provided the nonprofit raised an equal amount of
cash from other donors.
4. Regarding the previous transaction, the nonprofit raised $23,000 in cash from…
arrow_forward
Prepare a one-page memo for a client organization to explain the purpose of a capital funds project as well as your findings from the statement of revenues, expenditures, and changes in fund balance from that project.
arrow_forward
Can you complete the requirements listed below to this question please?
Requirement 1 --- prepare a contribution income statement in good form --- include/list all individual VC and FC
Requirement 2 --- calculate all requested values a thru d
REQUIRED: Calculations required for Requirement 2 values a thru d.
arrow_forward
Help & Save is a private not-for-profit entity that operates in Kansas. Swim For Safety is a private not-for-
profit entity that operates in Missouri. The leaders of these two organizations have decided to combine
forces on January 1, 2020, in order to have a bigger impact from their work. They are currently discussing
ways by which this combination can be created. The following are statements of financial position for both
charities at that date.
HELP & SAVE
Statement of Financial Position
January 1, 2020
Assets
Cash
$1,800,000
110,000
400,000
800,000
$3,110,000
Contributions receivable (net)
Investments
Buildings & equipment (net)
Total assets
Liabilities
Accounts payable and accrued liabilities
Notes payable
Total liabilities
$210,000
1,200,000
$1,410,000
Net Assets
$1,300,000
400,000
$1,700,000
$3,110,000
Net assets without donor restrictions
Net assets with donor restrictions
Total net assets
Total liabilities and net assets
SWIM FOR SAFETY
Statement of Financial Position
January…
arrow_forward
hrd.4
arrow_forward
Prepare the journal entries for the following transactions to consolidate financial statements from fund-level statements to government-wide statements.
1....Beginning accumulated depreciation was $500.
2....Depreciation during the year was $169
3....Beginning compensated absences was 500.
arrow_forward
Prepare journal entries to record the following events using the general fund and the general fixed assets account group: a. The general fund vouchered the purchase of trucks for $80,000. The purchase had been encumbered earlier in the year at $75,000. b. Several years ago, equipment costing $15,000 was acquired with general fund revenues. It was sold for $6,000, with proceeds belonging to the general fund. c. Early in the year, a citizen donated to the city land appraised at $100,000. She submitted plans for a new library and agreed to cover the total cost of construction, paying the company directly as work proceeded. At year-end, the building was two-thirds finished, with costs to date of $300,000. The expenditures are recorded in a capital projects fund. d. A snow plow was purchased with general fund cash for $92,000, which represented a cost of $110,000 less trade-in of $18,000 for an old snow plow originally purchased for $66,000 from special revenue funds. As an emergency…
arrow_forward
Image no allowed Right answer Give me
arrow_forward
Miscellaneous scenarios requiring journal entries
The following transactions and events pertain to Bean County’s General Fundfor the calendar year 2022:1. The entity receives invoices in early January 2023 for $25,000 for professional servicesobtained in 2022, and $32,000 for December 2022 utility services.2. The entity borrows $500,000 on August 1, 2022, in anticipation of thecollection of property taxes. The borrowed amount is due to be repaid onJanuary 31, 2023, with interest at the rate of 1.5 percent per annum.3. The entity invests $300,000 cash in a CD on November 1, 2022, at an interest rateof 1 percent per annum. The CD will mature on January 31, 2023.4. In September 2022, the entity receives and accepts supplies that had beenordered in August. The amount that had been encumbered was $40,000,but the amount of the approved invoice was $42,000.Prepare journal entries for the transactions and events listed above.Enter 0 or leave the field blank if no entry is required for calendar…
arrow_forward
1
arrow_forward
Please answer the questions in the following two photos. Thank you
arrow_forward
A citizen group raised funds to established an endowment for the Eastville City Liabrary. Under the terms of the trust agreement, the principal must be maintained, but the earnings of the fund are to be used to purchase database and periodical subscriptions for the library. A preclosing trial balance of the library permanant fund follows:
Debits: Cash $7,500; Investments $630,000; Expenditures - subscriptions $39,500 Accrued interest receivable $2,000
Credits: Additions to permanant endowments $625,000; Investment Income $48,000; Net increase in fair value of investments $5,000; Accounts Payable
Required:
A. Prepare any closing entries necessary at year-end
b. prepare a Statement of Revenuess, Expenditures, and Changes in Fund Balance for the library Permanant fund.
c. Prepare a balance sheet for the library permamant fund (use restricteed to Library for any spendable fund balance)
arrow_forward
Do not give answer in image
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Related Questions
- Required information Exercise 6-4 and Exercise 6-5 (Algo) [The following information applies to the questions displayed below.] The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Accounts payable Accounts receivable Accrued interest payable Accumulated depreciation Administrative and selling expenses Allowance for uncollectible accounts Capital assets Cash Charges for sales and services Cost of sales and services Depreciation expense Due from General Fund Interest expense Interest revenue Transfer in from General Fund Bank note payable Supplies inventory Totals Exercise 6-4 (Algo) $ Debits 31,900 55,500 732,000 99,500 509,000 53,500 18, 200 41,400 Credits $ 117,000 35,100 53,500 13,900 579,000 6,200 128,500 628,500 20,700 $1,561,700 $1,561,700 Required: a. Prepare the closing entries for December 31. b. Prepare…arrow_forwardFor each of the following transactions, determine the correct debit account from among the choices below: A. Expenditures B. Encumbrances C. Property, Plant, and Equipment (Capital Assets) D. Expenses E. Appropriations F. Other Financing Uses-Transfers Out G. Extraordinary Item H. Special Items I. Liabilities J. Answer not included in the above selections A proprietary fund signs a contract to build an office building with Do Good Construction for $10,000,000 Answer 1 Question 3 A proprietary fund makes a currently due principal payment on Bonds Payable Answer 2 Question 3 A proprietary fund recognizes and pays an interest payment that is currently due Answer 3 Question 3 A proprietary fund spends $5,000,000 of a capital grant for construction of a parking garage. Assume eligibility has been met Answer 4 Question 3 A city’s water supply in a proprietary fund is contaminated by terrorists. Cost of clean up, disposal and…arrow_forwardhttps://portal.laserfiche.com/Portal/DocView.aspx?id=638006&repo=r-49e9e584 1. Who is the CPA firm that audited Jefferson City, Missouri in October 31, 2022?2. The type of audit opinion given Jefferson City, Missouri at October 31, 2022?3. What 3 categories of funds does Jefferson City have?4. Which program in Jefferson City has the largest expenses?5. What is the largest source of revenue in Jefferson City for governmental activities?6. What was the October 31, 2022 net position of the airport fund?7. In the October 31, 2022 Statement of Activities how many years of financial information is presented?8. Does Jefferson City have any discretely presented component units? What are they?9. What entities were excluded from Jefferson Cities financial reports?10. Does Jefferson City include Cash Equivalents with its Cash balance?11. What is the threshold amount for capitalizing an asset for depreciation purposes?12. Over what amount of years are traffic lights depreciated?13. List one…arrow_forward
- Required information [The following information applies to the questions displayed below.] The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Accounts payable Accounts receivable Accrued interest payable Accumulated depreciation Administrative and selling expenses Allowance for uncollectible accounts Capital assets Cash Charges for sales and services Cost of sales and services Depreciation expense Due from General Fund Interest expense Interest revenue Transfer in from General Fund Bank note payable Supplies inventory Totals Debits Adjustments: $ 29,400 53,000 VILLAGE OF SEASIDE PINES ENTERPRISE FUND Reconciliation of Operating Income to Net Cash Provided by Operating Activities For the year ended December 31, 2024 722,000 98,000 504,000 51,000 17,700 40,900 19,700 $ 1,535,700 Credits $ 112,000 32,600 51,000…arrow_forward3 The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Debits Credits Accounts payable $ 108,000 Accounts receivable $ 27,400 Accrued interest payable 30,600 Accumulated depreciation 49,000 Administrative and selling expenses 51,000 Allowance for uncollectible accounts 13,000 Capital assets 714,000 Cash 96,800 Charges for sales and services 561,000 Cost of sales and services 500,000 Depreciation expense 49,000 Due from General Fund 17,300 Interest expense 40,500 Interest revenue 5,300 Transfer in from General Fund 117,600 Bank note payable 630,400 Supplies inventory 18,900 Totals $ 1,514,900 $ 1,514,900 Required: Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at…arrow_forward3 The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Debits Credits Accounts payable $ 108,000 Accounts receivable $ 27,400 Accrued interest payable 30,600 Accumulated depreciation 49,000 Administrative and selling expenses 51,000 Allowance for uncollectible accounts 13,000 Capital assets 714,000 Cash 96,800 Charges for sales and services 561,000 Cost of sales and services 500,000 Depreciation expense 49,000 Due from General Fund 17,300 Interest expense 40,500 Interest revenue 5,300 Transfer in from General Fund 117,600 Bank note payable 630,400 Supplies inventory 18,900 Totals $ 1,514,900 $ 1,514,900 Required: Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at the…arrow_forward
- 4. The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Accounts payable Accounts receivable Accrued interest payable Accumulated depreciation Administrative and selling expenses Allowance for uncollectible accounts Capital assets Cash Charges for sales and services Cost of sales and services Depreciation expense Due from General Fund Interest expense Interest revenue Transfer in from General Fund Bank note payable Supplies inventory Totals Debits $32,000 47,000 712,000 89,000 479,000 45,000 17,000 40,000 18,000 $1,479,000 Credits $ 96,000 28,000 45,000 12,000 550,000 4,000 119,000 625,000 $1,479,000 Required: a. Prepare the closing entries for December 31. b. Prepare the Statement of Revenues, Expenses, and Changes in Fund Net Position for the year ended December 31. c. Prepare the Net Position section of the…arrow_forward! Required information [The following information applies to the questions displayed below.] The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Accounts payable Accounts receivable Accrued interest payable Accumulated depreciation Administrative and selling expenses Allowance for uncollectible accounts Capital assets Cash Charges for sales and services Cost of sales and services Depreciation expense Due from General Fund Interest expense Interest revenue Transfer in from General Fund Bank note payable Supplies inventory Totals Required A Required B Complete this question by entering your answers in the tabs below. Required C VILLAGE OF SEASIDE PINES ENTERPRISE FUND Statement of Net Position December 31, 2024 Net Position: Net Investment in Capital Assets Unrestricted Total Net Position Debits Required: a.…arrow_forward! Required information [The following information applies to the questions displayed below.] The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Accounts payable Accounts receivable Accrued interest payable Accumulated depreciation Administrative and selling expenses Allowance for uncollectible accounts Capital assets Cash Charges for sales and services Cost of sales and services Depreciation expense Due from General Fund Debits $ Credits 96,000 $ 32,000 28,000 45,000 47,000 12,000 712,000 89,000 550,000 479,000 45,000 17,000 Interest expense Interest revenue Transfer in from General Fund Bank note payable Supplies inventory Totals 40,000 18,000 4,000 119,000 625,000 $1,479,000 $1,479,000 Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at the bottom of…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning