Question: i need the formula to put into excel B IU. . . AAlignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Imprudential, Inc.,

i need the formula to put into excel

B IU. . . AAlignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Imprudential, Inc., has an unfunded pension liability of $475 million that must be paid in 20 years. To assess the value of the firm's stock, financial analysts want to discount this liability back to the present. If the relevant discount rate is 6.1 percent, what is the present value of this liability? $ 475,000,000 Future value Years Interest rate Complete the following analysis. Do not hard code values in your calculations. Your answer should be a positive value. Present value

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

1. Prepare manual entries and complete the general and subsidiary ledgers. 2. Prepare an account receivable and account payable reconciliation of the subsidiary ledger accounts to the control...

please have it in equation form please enter as a formula 1. Use ratios to analyze a company's liquidity and solvency. Calculate Select Ratios - Excel ? - 5 X 1 FILE HOME INSERT PAGE LAYOUT FORMULAS...

Comparing Inventory Costing Methods using Excel's Basic Math Functions and Cell References Better Bottles, Inc. uses a periodic inventory system and has provided its current inventory Information....

By looking one table and other table I am looking dor excel formula in inside the yellow box. I don't need number just excel formula 10:47 Today 10:38 PM Edit A . Alignment Number | Conditional...

Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Check my work Use Apple's financial statements in Appendix A to answer the following. Required: 10 1. Using fiscal 2017 as...

please include the exact excel formulas used for the cells not just numbers 1. Use the income statement and balance sheet to prepare a statement of cash flows using the indirect method. XIA .. ? X...

Better Bottles, Inc. uses a periodic inventory system and has provided its current inventory information. The Controller has as you to prepare a comparison of the Ending Inventory and Cost of Goods...

Inventory Costing Methods using Excel's SUM and Basic Math Functions Better Bottles, Inc. uses a periodic inventory system and has provided its January inventory account activity. The Controller has...

Preparing a Multi-Step Income Statement using Excel's IF and Basic Math Functions Reading Readiness, Inc. has provided you its list of accounts and balances as of January 31. The Controller has asked...

Please only provide the formulas for the answer x All answers must be entered as a formula. Click OK to begin. OK Inventory Costing Methods using Excel's SUM and Basic Math Functions Better Bottles,...

Answers must be inputted by a formula Hayword, Inc. uses weighted average costing and has two departments and has provided data related to its mixing department for the month of July. The Controller...

Fisher Publishing Inc. is doing a financial feasibility analysis for a new book. Editing and preproduction costs are estimated at $45,000. The printing costs are a flat $7000 for setup plus $8.00 per...

On December 1, Newton Enterprises sells $100,000 of accounts receivable to a factor, receives 85% of the value of the factored accounts, and is charged a 12% commission on the gross amount of the...

1 Treynor - Black model [ 5 points ] Consider the single - index model applied to a stock ( or a portfolio of stock ) S : R _ ( S , t ) = \ alpha _ ( S ) + \ beta _ ( S ) R _ ( M , t ) + e _ ( S , t...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...