give the correct formula to calculate PV in column J? 145 Clipboard 2 fx A B 30
Fantastic news! We've Found the answer you've been seeking!
Question:
give the correct formula to calculate PV in column J?
Transcribed Image Text:
145 Clipboard 2 fx A B 30 31 32 Font =PV($E$36,1,,-145) Alignment D E F G H Payback Table View 33 Cost of new equipment (at year 0) 34 Corporate income tax rate - Federal Table 1- Data 191.10 million 26.0% 8.0% 8.28% 35 Corporate income tax rate - State of Maryland 36 Discount rate for the project using WACC (Tab 2) 37 Loan Amount 38 Loan Interest rate (Prime + 2) 171.99 million 5.25% L Number 39 40 Table 2- After-tax Cash Flow Table 41 (all figures in $ millions) Projected Cash Projected Cash Year Inflows from Operations Outflows from Operations Depreciation Expense Interest Expense Projected Taxable Income 42 Projected Projected Projected Federal State After-tax Income Income Cash Taxes Taxes Flows PV 3444 Excel function to use: SLN IPMT PV 0 ($191.10) 45 1 $850.0 $840.0 $23.89 $9.03 ($22.92) ($5.96) ($1.83) A6 $8.09 46 2 $900.0 $810.0 $23.89 $8.09 $58.02 $15.09 $4.64 $62.18 $57.43 47 3. $990.0 $870.0 $23.89 $7.11 $89.01 $23.14 $7.12 $82.63 $76.31 48 449 4 $1,005.0 $900.0 $23.89 $6.07 $75.04 $19.51 $6.00 $73.42 $67.80 5 $1,200.0 $1,100.0 $23.89 $4.98 $71.14 $18.50 $5.69 $70.84 $65.42 50 6 $1.300.0 $1.150.0 $23.89 $3.83 $122.29 $31.79 $9.78 $104.60 $96.60 51 7 52 86 $1.350.0 $1.300.0 $23.89 $2.61 $23.50 $6.11 $1.88 $39.40 $36.38 $1,320.0 $1,300.0 $23.89 $1.34 ($5.23) ($1.36) ($0.42) $20.44 $18.87 53 PV $426.91 54 NPV₁-calculated NPV including interest expense calculated NPV at the lower discount rate of 5.02% NPV 55 NPV 56 4 Instructions Cost of Capital Ready Accessibility: Investigate Type here to search Payback Budget Projections The Best F... C:\Users\kh... AdvanceFl... Inb DI 145 Clipboard 2 fx A B 30 31 32 Font =PV($E$36,1,,-145) Alignment D E F G H Payback Table View 33 Cost of new equipment (at year 0) 34 Corporate income tax rate - Federal Table 1- Data 191.10 million 26.0% 8.0% 8.28% 35 Corporate income tax rate - State of Maryland 36 Discount rate for the project using WACC (Tab 2) 37 Loan Amount 38 Loan Interest rate (Prime + 2) 171.99 million 5.25% L Number 39 40 Table 2- After-tax Cash Flow Table 41 (all figures in $ millions) Projected Cash Projected Cash Year Inflows from Operations Outflows from Operations Depreciation Expense Interest Expense Projected Taxable Income 42 Projected Projected Projected Federal State After-tax Income Income Cash Taxes Taxes Flows PV 3444 Excel function to use: SLN IPMT PV 0 ($191.10) 45 1 $850.0 $840.0 $23.89 $9.03 ($22.92) ($5.96) ($1.83) A6 $8.09 46 2 $900.0 $810.0 $23.89 $8.09 $58.02 $15.09 $4.64 $62.18 $57.43 47 3. $990.0 $870.0 $23.89 $7.11 $89.01 $23.14 $7.12 $82.63 $76.31 48 449 4 $1,005.0 $900.0 $23.89 $6.07 $75.04 $19.51 $6.00 $73.42 $67.80 5 $1,200.0 $1,100.0 $23.89 $4.98 $71.14 $18.50 $5.69 $70.84 $65.42 50 6 $1.300.0 $1.150.0 $23.89 $3.83 $122.29 $31.79 $9.78 $104.60 $96.60 51 7 52 86 $1.350.0 $1.300.0 $23.89 $2.61 $23.50 $6.11 $1.88 $39.40 $36.38 $1,320.0 $1,300.0 $23.89 $1.34 ($5.23) ($1.36) ($0.42) $20.44 $18.87 53 PV $426.91 54 NPV₁-calculated NPV including interest expense calculated NPV at the lower discount rate of 5.02% NPV 55 NPV 56 4 Instructions Cost of Capital Ready Accessibility: Investigate Type here to search Payback Budget Projections The Best F... C:\Users\kh... AdvanceFl... Inb DI
Expert Answer:
Answer rating: 100% (QA)
To calculate the Present Value PV in column J you can use the PV functi... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Create a space themed single player variation of Battleship. This is a classic guessing game dating back to the 1930s in which players try to shoot enemy ships in a grid by guessing grid coordinates
-
(20 points)Write a program that prompts the user to input five decimal numbers. The program should then add the five decimal numbers, convert the sum to the nearest integer, and print the result....
-
Explain how to apply the rules of Section (61)a to determine taxable items.
-
A ball is thrown from the roof of a 1 0 0 m high building at a speed of 1 0 m / s making 3 0 angles with the horizontal. A child waiting on the ground at the door of the building falls into a coma...
-
What must one consider to determine if NAFTA was beneficial to the U.S.?
-
You have just been hired as the new supervisor of an audit team for a national accounting firm. With four years of experience, you feel technically well prepared for the assignment. However, this is...
-
Phil Rammers is confused about the source documents used in assigning materials and labor costs. Identify the documents and give the entry for each document.
-
A violin string has a length of 0.350 m and is tuned to concert G, with fG = 392 Hz. Where must the violinist place her finger to play concert A, with fA = 440 Hz? If this position is to remain...
-
If mZMPL=63, find each measure. N M a) mJK = d) mKNM = b) mNJ = = e) mMJL = c) mJL = f) mJLK =
-
Kenmare Architects Ltd. (KAL) was incorporated and commenced operations on January 1, 2014. Sheila Kenmare, the company's only employee, consults with various clients and uses expensive equipment to...
-
In the material below there is presented the population structure of Finland. Calculate the amount of 15-64-year old persons in the years 1900, 1950, 1990, 2000, 2010 and 2016. Make a scatter diagram...
-
What are the determining factors for macroscopic observations? Explain
-
How should VinFast launch its eSUVs in Canada? - Market Trends - Competitive Analysis - Who's the target customer? - Product - Price - Promotion Place You need to write a marketing research report...
-
What are the underlying sociopolitical dynamics that drive social movements, and how do these movements impact societal norms and public policies ?
-
The city is issuing bonds to raise money for a building project. You obtain a $8200 bond that pays 9% simple interest annually that matures in 6 years. How much interest will you earn?
-
Standard Deduction Amounts Filing Status 2020 Single 12,400 Married Filing Jointly or Surviving Spouse 24,800 Head of Household 18,650 Married Filing Separately 12,400 Child Tax Credit (per child)...
-
While you are having a discussion with a colleague, she mentions that she believes it would be much easier and would have a minimal effect on the financial statements if we eliminated all adjusting...
-
Show that every group G with identity e and such that x * x = e for all x G is abelian.
-
During 2012, Palo Fiero purchases the following property for use in his manufacturing business: Palo uses the accelerated depreciation method under MACRS, if available, and does not make the election...
-
Jason and Mary Wells, friends of yours, were married on December 30, 2012. They know you are studying taxes and have come to you with a question concerning their filing status. Jason and Mary would...
-
On September 14, 2012, Jay purchased a passenger automobile that is used 75 percent in his accounting business. The automobile has a basis for depreciation purposes of $35,000, and Jay uses the...
-
A company often test-markets a proposed product in a specific area or location. Suppose that you wish to test-market your new, revolutionary SuperWax car wax, which requires only one application for...
-
The idea for New Belgium Brewing Company began with a bicycling trip through Belgium, where some of the worlds finest ales have been brewed for centuries. As Jeff Lebesch, a U.S. electrical engineer,...
-
It is helpful to think of a total product offering as having a combination of three interdependent elements: the core product itself, its supplemental features, and its symbolic or experiential...
Study smarter with the SolutionInn App