Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. i need it in excel formulas. u - ${a} $4,030 {

i need it in excel formulas. U - ${A} $4,030 {B}...

90.2K

Verified Solution

Question

Finance

i need it in excel formulas.
image
U - ${A} $4,030 {B} Years 25 ${C} $47,941 {D}% 3.39% Problem: DG has decided to retire at age of 65. He would like to have monthly pension of $ 4030. His IRF earns 3.00% per annum compounded semi-annually for 25 years after retirement A. How much money DG need in his account when he retires? B. How much money DG need in account now at the age of 25 years. a C. When He retires, he intend to buy his dream car and will contribute a down payment of $10000. If the vehicle costs $47941 and can be financed for 3.39% compounded annually, what is his monthly payment on vehicle if he finance for 96 months

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students