The City of New York is planning to build a library in its downtown area. Due to budgetary
constraint, the City faces the decision on whether to build it all now (full development), or build
part now (delayed plan) and complete the project in 10 years later.
The City hires you to do a present cost analysis to compare the options described below for
perpetual life at 4% effective interest rate:
1. First cost Full development Delayed plan
$1,800,000 $900,000 now
________________________________________ $1,100,000 in 10 years
2. Annual disbursements _______ $140,000/yr $80,000/yr for 10 years
$160,000/yr thereafter
Clearly describe your engineering economic analysis and state your suggestion to the City of
New York.
Make sure to use:
To find the equivalent P
âPV(i,n,A,F,Type)
To find the equivalent A
âPMT(i,n,P,F,Type)
To find the equivalent F
âFV(i,n,A,P,Type)
To find n
NPER(i,A,P,F,Type)
To find i
RATE(n,A,P,F,Type,guess)
Where:
i = interest
n = number of periods
A = Annual Value (or Worth)
P = Present Value (or Worth)
F = Future Value (or Worth)
The City of New York is planning to build a library in its downtown area. Due to budgetary
constraint, the City faces the decision on whether to build it all now (full development), or build
part now (delayed plan) and complete the project in 10 years later.
The City hires you to do a present cost analysis to compare the options described below for
perpetual life at 4% effective interest rate:
1. First cost Full development Delayed plan
$1,800,000 $900,000 now
________________________________________ $1,100,000 in 10 years
2. Annual disbursements _______ $140,000/yr $80,000/yr for 10 years
$160,000/yr thereafter
Clearly describe your engineering economic analysis and state your suggestion to the City of
New York.
Make sure to use:
| To find the equivalent P | âPV(i,n,A,F,Type) |
| To find the equivalent A | âPMT(i,n,P,F,Type) |
| To find the equivalent F | âFV(i,n,A,P,Type) |
| To find n | NPER(i,A,P,F,Type) |
| To find i | RATE(n,A,P,F,Type,guess) |
Where:
i = interest
n = number of periods
A = Annual Value (or Worth)
P = Present Value (or Worth)
F = Future Value (or Worth)
Related questions
| The City of Pfeiffer starts the year of 2015 with the General Fund and an enterprise fund. The General Fund has two activities: education and parks/recreation. For convenience, assume that the General Fund holds $123,000 cash and a new school building costing $1 million. The city utilizes straight-line depreciation. The building has a 20-year life and no salvage value. The enterprise fund has $62,000 cash and a new $600,000 civic auditorium with a 30-year life and no salvage value. The enterprise fund monitors just one activity, the rental of the civic auditorium for entertainment and other cultural affairs. |
| The following transactions for the city take place during 2015. Assume that the cityâs fiscal year ends on December 31. |
| a. | Decides to build a municipal park and transfers $70,000 into a capital projects fund and immediately expends $20,000 for a piece of land. The creation of this fund and this transfer were made by the highest level of government authority. |
| b. | Borrows $110,000 cash on a long-term bond for use in creating the new municipal park. |
| c. | Assesses property taxes on the first day of the year. The assessment, which is immediately enforceable, totals $600,000. Of this amount, $510,000 will be collected during 2015 and another $50,000 is expected in the first month of 2016. The remainder is expected about halfway through 2016. |
| d. | Constructs a building in the park in (b) for $80,000 cash so that local citizens can play basketball and other sports. It is put into service on July 1 and should last 10 years with no salvage value. |
| e. | Builds a sidewalk around the new park for $10,000 cash and puts it into service on July 1. It should last for 10 years, but the city plans to keep it up to a predetermined quality level so that it will last almost indefinitely. |
| f. | Opens the park and charges an entrance fee of only a token amount so that it records the park, therefore, in the General Fund. Collections during this first year total $8,000. |
| g. | Buys a new parking deck for $200,000, paying $20,000 cash and signing a long-term note for the rest. The parking deck, which is to go into operation on July 1, is across the street from the civic auditorium and is considered part of that activity. It has a 20-year life and no salvage value. |
| h. | Receives a $100,000 cash grant for the city school system that must be spent for school lunches for the poor. Appropriate spending of these funds is viewed as an eligibility requirement of this grant. During the current year, $37,000 of the amount received was properly spent. |
| i. | Charges students in the school system a total fee of $6,000 for books and the like. Of this amount, 90 percent is collected during 2015 with the remainder expected to be collected in the first few weeks of 2016. |
| j. | Buys school supplies for $22,000 cash and uses $17,000 of them. The General Fund uses the purchases method. |
| k. | Receives a painting by a local artist to be displayed in the local school. It qualifies as a work of art, and officials have chosen not to capitalize it. The painting has a value of $80,000. It is viewed as inexhaustible. |
| l. | Transfers $20,000 cash from the General Fund to the Enterprise Fund as a capital contribution. |
| m. | Orders a school bus for $99,000. |
| n. | Receives the school bus and pays an actual cost of $102,000. The bus is put into operation on October 1 and should last for five years with no salvage value. |
| o. | Pays salaries of $240,000 to school teachers. In addition, owes and will pay $30,000 during the first two weeks of 2016. Vacations worth $23,000 have also been earned but will not be taken until July 2016. |
| p. | Pays salaries of $42,000 to city auditorium workers. In addition, owes and will pay $3,000 in the first two weeks of 2016. Vacations worth $5,000 have also been earned but will not be taken until July 2016. |
| q. | Charges customers $130,000 for the rental of the civic auditorium. Of this balance, collected $110,000 in cash and will collect the remainder in April 2016. |
| r. | Pays $9,000 maintenance charges for the building and sidewalk in (d) and (e). |
| s. | Pays $14,000 on the bond in (b) on the last day of 2015: $5,000 principal and $9,000 interest. |
| t. | Accrues interest of $13,000 on the note in (g) as of the end of 2015, an amount that it will |
| u. | Assumes that a museum that operates within the city is a component unit that will be discretely presented. The museum reports to city officials that it had $42,000 of direct expenses this past year and $50,000 in revenues from admission charges. The only assets that it had at year-end were cash of $24,000, building (net of depreciation) of $300,000, and a long-term liability of $210,000. |
| Prepare the 2015 fund financial statements for the governmental funds and the proprietary funds. A statement of cash flows is not required. Assume that âavailableâ is defined as within 60 days and that all funds are major. The General Fund is used for debt repayment. Assume that major funds are labeled as âSpecial Revenue Fundâ and âCapital Projects Fundâ. (Amounts to be deducted should be indicated by a minus sign.) |
I need Answers to Question from P - V!
I know it's a lot but they are all small questions related to the same case so I didn't know how to split it into multiple questions. I would really appreciate the help, as I need a way to compare my answers.
Dallas & Associates Financial Statement Preparation & Analysis
You have been hired as a senior financial analyst for Dallas and Associates and you are in charge of preparing the financial statements and presenting an annual analysis at the board meeting.
Overview of Dallas & Associateâs Balance Sheet
The assets of Dallas & Associates in 2017 have both current assets and net plant and equipment. It has total assets of $ 7.5 million and net plan and equipment equals $5 million. Dallas & Associateâs only finances with $2.5 million long-term debt, $500,000 notes payable and total common equity of $3.5 million. The firm does have $400,000 accounts payable and $600,000 accruals on its balance sheet. Now assume the firmâs current assets consist entirely of cash and cash equivalence, account receivables and inventories. If it has 1.5 million cash and cash equivalents and $400,000 account receivables.
Dallas & Associates Income Statement in 2017 (dollars are in millions)
| Sales | 15 |
| Operating costs excluding depreciation and amortization | 5 |
| EBITDA | 10 |
| Depreciation & Amortization | 0.6 |
| EBIT | 9.4 |
| Interest | 0.4 |
| EBT | 9 |
| Taxes (40%) | 3.6 |
| Net Income Cash Dividends | 5.4 2.0 |
Use the above information to answer the following questions. Make sure to include the calculation steps/ formula.
Questions:
a. Prepare the balance sheet.
| Total Assets | Liabilities & Shareholderâs Equity |
b. What is the amount of total liabilities and equity that appears on the firmâs balance?
c. What is the amount of current assets?
d. What is the balance of current liabilities?
e. What is the amount of companyâs inventory?
f. What is the amount of total liabilities?
g. What is the amount of total debt?
h. What is the amount of total capital?
i. What is the amount of net working capital?
j. What is the amount of net operating working capital?
k. If by the end of 2017, the retained earnings of John and Jon is $2.5 million, what is the amount of paid-in capital?
l. If John & Jon decides to purchase $500,000 market securities by using its cash, how does this action would affect its current asset position?
m. As the Income of Statement shows in 2017 Dallas associates actually gave out $2 million cash dividends, what is the amount of retained earnings?
n. What is the amount of operating income?
o. What are the operating margin and the profit margin?
p. What is the average length of time that Dallas associates must wait after making a sale before it receives cash?
q. What is the ratio we generally use to estimate a firmâs ability to meet its annual interest payments? And calculate that ratio for Dallas associates.
r. What are the fixed assets turnover ratio and the total asset turnover ratio?
s. What is the ratio of total debt to total capital?
t. What is the ratio of return on common equity?
u. Assume between 2016 and 2017, net operating working capital has increased by $500,000, calculate Dallas & Associates free cash flow. (Hint: use this formula. FCF = [EBIT (1-T) +Depreciation & Amortization] â [Capital Expenditures + Change on Net Operating Working Capital])
v. Now after you present your analysis on the meeting, the CEO would like to see higher sales and a forecasted net income of $10.8 million. Assume that operating costs (excluding depreciation and amortization) are still one third of sales and that depreciation and amortization and interest expenses will increase by 10%. The tax rate which is 40%, will remain the same. What level of sales would generate $10.8 million in net income?
THANK YOU!
