Calculate net present value and benefit cost ratio

Assignment Help Financial Accounting
Reference no: EM132641354

Assignment

Question 1: 1. Using the information presented at this discussion, use the Excel file provided to calculate Net Present Value (NPV), Benefit Cost Ratio (BCR), Internal Rate of Return (IRR) of building the parking. Complete the sensitivity analysis using guideline provided in the Excel file.

Question 2: Consider a scenario that parking utility usage would be affected and using Excel Scenario Manager, estimate the new NPV, BCR, IRR.

Question 3: Using the analysis in the excel file, the presentation provided by PA, mayor, traffic commissioner, and city's director of finance, we need one-page recommendation on whether the city of Dovetown should proceed with constructing the proposed garage or not? Support your claims citing the relevant analysis.

Attachment:- Dovetown Parking Authorityl.zip

Reference no: EM132641354

Questions Cloud

What is the difference between probation and parole : What is the difference between probation and parole? What is your understanding of the role of community supervision in the overall criminal justice system?
Construct worker-machine chart : Each of the two sides of a hand-operated toaster can be operated independently of the other. A spring holds each side of the toaster shut, and each side must be
Write an article to address the four amendments : You have been tasked to write an article to address the four amendments that you feel have the most significance on the criminal justice system.
Project on mangerial effectiveness : Write a one page summary of why you chose this topic and how it relates to managerial effectiveness - project on Mangerial effectiveness
Calculate net present value and benefit cost ratio : Calculate Net Present Value (NPV), Benefit Cost Ratio (BCR), Internal Rate of Return (IRR) of building the parking. Complete the sensitivity analysis
Discussing a specific social movement : In a paper (minimum 2-page) paper discussing a specific social movement that brought about heightened concerns about the plight of a victim group.
Determine the equivalent annual worth of a cash flow : Determine the equivalent annual worth of a cash flow that has a first cost $72,000 in year 0, and annual costs of $7,500 in year 3 through year 8? Use an intere
Importance of the ethics in engineering decisions making : Write down about the importance of the ethics in engineering decisions making
What are the goals of alternative sanctions : Write a 700- to 1,050-word paper that describes roles and functions of individuals in the criminal justice system and how victimization affects each role.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Different from the bonds face value

Bonds usually sell at a price that is different from the bond's face value. When this happens, the bonds are sold at a discount or premium. Discuss the market forces that would cause a bond to sell at a price that is different from its face value.

  How much money did shen borrow

How much money did Shen borrow? Assume that there are 365 days in a year, and do not round any intermediate computations.

  Prepare the journal entries needed to record investments

Prepare the journal entries needed to record the investments of Levy and Parcells.

  The vacation benefits payable account

A balance of 49,900 in the vacation benefits payable account. During month employees earned an additional 3,110 in vacation benefits, but some employees used vacation days that amounted to 2,490 of the benefits, charged to wage expense when it was pd..

  Record the general journal entry for sept

Record the general journal entry for Sept 7th and Dec 31.HBC gave rotary sports a 60 day, 12% , 50,000 note to extend rotary sports overdue account with HBC

  Identify and analyze all transactions on swartz records

Investments in Bonds and Stock Swartz Inc. enters into the following transactions during 2010: July 1: Paid $10,000 to acquire on the open market $10,000 face value of Gallatin bonds.

  Total amount reported on the consolidated balance sheet

During the current year, ABC Corporation sold inventory costing $80,000 to DEF for $100,000. ABC owns 80 percent of the outstanding shares of DEF Corporation. DEF has paid ABC and DEF still has all of this inventory on the last day of the year.

  Journal entries to record the benefit of loss carry back

Trenton Co. incurred a net operating loss of $850,000 in 2014. Combined income of 2012 and 2013 was $650,000. The tax rate for all years is 30%. Trenton elects the carry back option. Prepare the journal entries to record the benefit of loss carry bac..

  Credit account titles are automatically indented when amount

Prophet Company issued $720,000, 9%, 30-year bonds on January 1, 2014, at 106. Interest is payable annually on January 1. Prophet uses straight-line amortization for bond premium or discount. Credit account titles are automatically indented when amou..

  Two types of handbags-standard and custom

Wilkins Inc. has two types of handbags: standard and custom. The controller has decided to use a plantwide overhead rate based on direct labor costs. The president has heard of activity-based costing and wants to see how the results would differ if t..

  Book value-unamortized issue cost-how much interest expense

The Evermaster Co. issues at par a $100,000 8% bond on Jan. 1, 2010 which matures after 5 years. Bond issue costs are $7721.73 . The bond pays interest on July 1 and Jan 1. How much interest expense will be recognized under IFRS on July 1, 2010 ? How..

  What is the internal rate of return

the first two years and $30,000 for the following two years. What is the internal rate of return

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd