Question

In: Finance

Please use excel and show the excel formulas in detail. Alice wants to deposit $35,000 now...

Please use excel and show the excel formulas in detail.

Alice wants to deposit $35,000 now $45,000 at the end of 6 years at a bank that pays 10% interest compounded semiannually. She wants to withdraw an amount every year for the first 6 years and to withdraw exactly $1000 more for the following four years. What is the maximum amount she could withdraw in year 1?

Solutions

Expert Solution

The maximum amount which can be withdrawn in the first six years = 8,095.22

Solved using Excel Solver:

Note: There is no condition that at the end of 10 years, the balance has to be zero, so balance is only minimized.


Related Solutions

Use excel and please show both formulas and numbers. Answer this: Now if I were investing...
Use excel and please show both formulas and numbers. Answer this: Now if I were investing my $1200 a year at 12% with no children and I win the lottery at year 30 and win $1,000,000 cash, how much money can I blow today (at year 30) and still have the $2,000,000 when I retire at year 40. not sure but it might be a continuation of - If I want to invest $1200 a year for 20 years and...
***Excel is required to solve this problem. Please use excel and show all formulas used in...
***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
USE EXCEL ONLY AND SHOW FORMULAS PLEASE! An office building is purchased with the following projected...
USE EXCEL ONLY AND SHOW FORMULAS PLEASE! An office building is purchased with the following projected cash flows: • NOI is expected to be $130,000 in year 1 with 5 percent annual increases. • The purchase price of the property is $720,000. • 100 percent equity financing is used to purchase the property. • The property is sold at the end of year 4 for $860,000 with selling costs of 4 percent. • The required unlevered rate of return is...
***PLEASE USE EXCEL AND SHOW FORMULAS**** Barry and Samantha are starting to take their retirement planning...
***PLEASE USE EXCEL AND SHOW FORMULAS**** Barry and Samantha are starting to take their retirement planning seriously. They are both 46 and plan to retire in 20 years at the age of 66. They expect to live 20 years in retirement (a life expectancy of 86). Between their 401k and IRA accounts they currently have $84,295 in retirement savings. They currently have a combined income of $80,000 per year and expect to be able to live comfortably in retirement with...
Please, use Excel and show the formulas The Oliver Cards Company is a card manufacturer. All...
Please, use Excel and show the formulas The Oliver Cards Company is a card manufacturer. All direct materials and conversion costs are applied to all of Proball Trading Cards’ products at an even rate throughout the manufacturing process. For August, the beginning work in process inventory for the Finishing Department was 9,800 units that averaged 65 percent complete for conversion costs. Materials were done. Ending work in process inventory was 18,600 units averaged 85 percent complete for conversion costs. Materials...
Use Excel and show formulas please You are getting paid lots of money to determine the...
Use Excel and show formulas please You are getting paid lots of money to determine the best depreciation method for a piece of equipment that costs $50,000 and has a zero salvage value at the end of a 10-year depreciable life. Compute the depreciation schedules for each of the following methods: a) straight line depreciation b) double declining balance depreciation (DDB) c) 100% bonus depreciation d) MACRS
Please show how to write the formulas for these in Excel. That is what the assignment...
Please show how to write the formulas for these in Excel. That is what the assignment requires and I don't know how to do it. Thank you! All are in column D. Cell numbers that matter are noted on the left. Suppose the risk-free interest rate is 4%. a. Having $200 today is equivalent to having what amount in one year? b. Having $200 in one year is equivalent to having what amount today? c. Which would you prefer, $200...
PLEASE USE EXCEL FORMULAS, AND SHOW THEM + HOW YOU USED THEM. NEEDS TO BE CREATED...
PLEASE USE EXCEL FORMULAS, AND SHOW THEM + HOW YOU USED THEM. NEEDS TO BE CREATED IN EXCEL! IF YOU DO NOT CREATE THIS IN EXCEL WITH ALL THE RIGHT FORMULAS (SHOW ME HOW AND WHAT FORMULAS) YOU WILL NOT GET A POSITIVE REVIEW. DO NOT COPY THE OTHER ANSWERS, DO IT YOURSELF!!!! A company is considering three capital budgeting projects. Data relative to each is given below. Each project has a life of 5 years. The company uses the...
PLEASE USE EXCEL FORMULAS, AND SHOW THEM + HOW YO USED THEM. NEEDS TO BE CREATED...
PLEASE USE EXCEL FORMULAS, AND SHOW THEM + HOW YO USED THEM. NEEDS TO BE CREATED IN EXCEL! A company is considering three capital budgeting projects. Data relative to each is given below. Each project has a life of 5 years. The company uses the NPV method to evaluate capital budgeting projects and its discount rate is 9%. Project A Project B Project C Initial cash outlay (cost) -$5,000,000 -$6,000,000 -$3,000,000 Cash inflows per year $1,500,000 $1,800,000 $ 600,000 Residual...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT