I am trying to find the correct way to answer this question, so far when re-creating the formulas from the examples on this site, it has not produced the correct answer. I'm not sure where I am going wrong.

"Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with a retirement income of $24,500 per month for 20 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of $325,000. Third, after he passes on at the end of the 20 years of withdrawals, he would like to leave an inheritance of $1,025,000 to his nephew Frodo. He can afford to save $2,200 per month for the next 10 years. If he can earn an EAR of 11 percent before he retires and an EAR of 8 percent after he retires, how much will he have to save each month in Years 11 through 30? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Monthly savings $ "

H I J K L M N 12 30 CORRECT according to Chegg, wrong according to class... payments per year Retire in years first pmt monthly annuity pmt annuity term annuity term years cabin purchase price time until cabin purchase balance at end of annuity end of annuity He can afford to save savings term EAR EAR 361 months $24,500 240 months 20 $325,000 120 months $1,025,000 (inheiritance) 240 $2,200 per month 120 months 11% before retirement 8% after retirement convert EAR to APR convert EAR to APR 0.1048 0.0772 10.48% APR pre-retirement 7.72% APR pre-retirement Monthly PV Inheritance PV $3,429,461.00 $101,861.77 $3,531,322.77 needed at retirement savings / mo $ 2,200 rate 10.48% time (years) 10 FV of savings $463,298.72 amount left after cabin cost time left to retire (years) FV of bal. after cabin cost $138,298.72 10 $392,688.30 Short by... $3,138,634.47 FV RATE YEARS $3,138,634.47 10.48% 10 MONTHLY SAVINGGS $14,903.98 months CORRECT according to Chegg, wrong according to class... months payments per year 12 Retire in years 30 first pmt =(180*179)+1 monthly annuity pmt 24500 annuity term =)84*179 annuity term years 20 cabin purchase price 325000 time until cabin purchase =10*179 balance at end of annuity 1025000 end of annuity =20*179 He can afford to save 2200 savings term =10*179 EAR 0.11 EAR 0.08 months (inheiritance) per month months before retirement after retirement convert EAR to APR =NOMINAL(J91,179) convert EAR to APR =NOMINAL(J92,379) =K96 =K97 APR pre-retirement APR pre-retirement Monthly PV =PV(L97/179,79*180,-182) Inheritance PV =PV(L97/179,379 380,,-487) =SUM(K99:K100) needed at retirement savings / mo =)89 rate =L96 time (years) 10 FV of savings =FV(L96/179,K105*179,-489) left after cabin cost = 106-185 time left to retire (y =)84-K105 bal. after cabin cost =FV(L96/179,79*K109,,-K108) Short by... =K101-K110 FV =K112 RATE =L96 YEARS =K109 1ONTHLY SAVINGGS EPMT(K115/179,179*K116,,-K114)