Need help on which excel formula to use on finding at the end of which month will it be for the loan outstanding to be less than 50% of the original loan amount for the first time?

At the end of which month will it be for the loan outstanding (loan balance) to be less than 50% of the original loan amount for the first time? Answer each question using AT LEAST ONE of Excel's TVM functions from among =PV, EFV, EPMT, ERATE, ENPER, =IPMT, EPPMT, ECUMIPMT, ECUMPRINC. A B D E F G H I J K L M WACT1001 Excel Assignment Number of years 24 Student number digit by digit 45807361 Number of months 288 Annual Percentage Rate (112) 8.00% Monthly interest rate 0.67% Loan amount $458,361 This is the first 3 and the last 3 digits in your student number Fixed monthly repayment amount $3,584.63 Answer must be positive (greater than o) DO NOT Round any amounts in the Amortisation Schedule. Use format commands to display as currency. Loan Amortisation Schedule Month Balance at the beginning of month Interest paid Principal paid Balance at the end of month 1 $458,361.00 $3,055.74 $528.89 $457,832.11 2 $457,832.11 $3,052.21 $532.42 $457,299.69 3 $457,299.69 $3,048.66 $535.97 $456,763.73 4 $456,763.73 $3,045.09 $539.54 $456,224.19 5 $456,224.19 $3,041.49 $543.14 $455,681.05 6 $455,681.05 $3,037.87 $546.76 $455,134.29 7 $455,134.29 $3,034.23 $550.40 $454,583.89 8 $454,583.89 $3,030.56 $554.07 $454,029.82 9 $454,029.82 $3,026.87 $557.77 $453,472.05 10 $453,472.05 $3,023.15 $561.48 $452,910.57 11 $452,910.57 $3,019.40 $565.23 $452,345.34 12 $452,345.34 $3,015.64 $569.00 $451,776.34 13 $451,776.34 $3,011.84 $572.79 $451,203.56 14 $451,203.56 $3,008.02 $576.61 $450,626.95 15 $450,626.95 $3,004.18 $580.45 $450,046.50 16 $450,046.50 $3,000.31 $584.32 $449,462.18 17 $449,462.18 $2,996.41 $588.22 $448,873.96 18 $448,873.96 $2,992.49 $592.14 $448,281.82 19 $448,281.82 $2,988.55 $596.09 $447,685.74 20 $447,685.74 $2,984.57 $600.06 $447,085.68 21 $447,085.68 $2,980.57 $604.06 $446,481.62 22 $446,481.62 $2,976.54 $608.09 $445,873.53 23 $445,873.53 $2,972.49 $612.14 $445,261.39 24 $445,261.39 $2,968.41 $616.22 $444,645.17 25 $444,645.17 $2,964.30 $620.33 $444,024.84 26 $444,024.84 $2,960.17 $624.47 $443,400.37 27 $443,400.37 $2,956.00 $628.63 $442,771.74 28 $442,771.74 $2,951.81 $632.82 $442,138.92 - 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 488 9 50 51 52 53 54 55 56 57 58 59 $442.138.92 $441,501.88 $440,860.60 $440.215.04 $439,565.18 $438,910.98 $438.252.42 $437,589.47 $436,922.10 $436,250.29 $435.573.99 $434,893.19 $434,207.84 $433.517.93 $432,823.42 $432.124.28 $431,420.48 $430,711.98 $429,998.76 $429,280.79 $428,558.03 $427,830.45 $427,098.03 $426,360.72 $425,518.49 $424,871.31 $424,119.16 $423,361.99 $422,599.77 $421,832.47 $421,060.06 $420,282.49 $419,499.74 $418,711.78 $417,918.56 $417,120.05 $416,316.22 $415.507.03 $414,692.45 52.94759 $2,943.35 $2,939.07 $2,934.77 2,930.43 $2,926.07 $2,921.68 $2,917.26 $2,912.81 $2,908.34 $2,903.83 $2,899.29 $2,894.72 $2,890.12 $2,885.49 $2,880.83 $2,876.14 $2,871.41 $2,866.66 $2,861.87 $2,857.05 $2,852.20 $2,847.32 $2,842.40 $2,837.46 $2,832.48 $2,827.46 $2,822.41 $2,817.33 $2,812.22 $2,807.07 $2,801.88 $2,796.66 $2,791.41 $2,786.12 $2,780.80 $2,775.44 $2,770.05 $2,764.62 $637.04 5641.29 5645.56 $649.86 $654.20 $658.56 $662.95 $667.37 5671.82 $676.30 $680.80 $685.34 $68991 $694.51 $699.14 $703.80 $708.49 $713.22 $717.97 $722.76 $727.58 5732.43 $737.31 $742.23 S747.17 5752.16 $757.17 $762.22 S767.30 $772.41 S777.56 $782.75 578797 $793.22 $798.51 $803.83 809.19 S814.58 S820.01 $441.501.8 $440,860.60 $440.215.04 $439,565.18 $438.910.98 $438.252.42 $437,589.47 $436,922.10 $436,250.29 $435.573.99 $434,893.19 $434.207.84 $433,517.93 $432,823.42 $432.124.28 $431,420.48 $430,711.98 $429,998.76 $429,280.79 $428,558.03 $427,830.45 $427,098.03 $426.360.72 425,618.49 $424,871.31 $424,119.16 $423,361.99 $422,599.77 $421,832.47 $421,060.06 $420,282.49 $419,499.74 $418,711.78 $417918.56 $417,120.05 $416,316.22 $415,507.03 $414,692.45 $413,872.43 60 61 62 63 64 65 66 67 57 58 59 6 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 6 77 78 79 80 81 882 83 84 885 86 87 88 89 90 S422.599.77 $421,832.47 $421,060.06 $420,282.49 $419,499.74 $418,711.78 $417,918.56 $417,120.05 $416,316.22 $415.507.03 $414,692.45 $413,872.43 $413,046.95 $412,215.97 $411,379.44 $410,537.34 $409,689.62 $408,836.26 $407,977.20 $407,112.42 $406,241.87 $405,365.52 $404,483.32 $403,595.25 $402,701.25 $401,801.30 S400, 895.34 $399,983.35 $399,065.27 $398,141.07 $397.210.72 $396,274.16 $395,331.35 $394,382.26 $393,426.85 $392,465.06 $391,496.87 $390,522.21 $389,541.06 $388,553.37 $2,817.33 2,812.22 $2,807.07 $2,801.88 $2,796.66 $2,791.41 $2,786.12 $2,780.80 $2,775.44 2.770.05 2,764.62 $2,759.15 $2,753.65 $2,748.11 $2,742.53 2,736.92 2,731.26 $2,725.58 $2,719.85 $2,714.08 $2,708.28 $2,702.44 $2,696.56 $2,690.63 $2,584.68 $2,678.68 $2,572.64 $2,666.56 $2,660.44 2,654.27 $2,648.07 $2,641.83 $2,635.54 $2,629.22 $2,622.85 $2,616.43 $2,609.98 $2,603.48 $2,596.94 $2,590.36 S767.30 S772.41 S777.56 $782.75 $787.97 $793.22 $798.51 $803.83 5809.19 S814.58 820.01 $825.48 830.98 $836.52 842.10 $847.72 $853.37 $859.06 $864.78 $870.55 $876.35 $882.19 $888.08 5894.00 $899.96 $905.96 5912.00 5918.08 5924.20 $930.36 5936.56 $942.80 5949.09 $955.42 $961.79 $968.20 5974.65 $981.15 5987.69 $994.28 $421,832.47 $421,060.06 $420,282.49 419,499.74 $418,711.78 $417,918.56 $417.120.05 $416,316.22 $415,507.03 $414,692.45 $413,872.43 $413,046.95 $412,215.97 $411,379.44 $410,537.34 S409,689.62 $408,836.26 $407,977.20 $407,112.42 $406,241.87 S405,365.52 S404,483.32 S403,595.25 $402,701.25 $401,801.30 $400,895.34 $399,983.35 $399,065.27 $398,141.07 $397,210.72 $396,274.16 $395,331.35 $394,382.26 $393,426.85 $392,465.06 $391,496.87 $390,522.21 $389,541.06 $388,553.37 $387559.10 91 92 93 94 95 96 97 98 9 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 $387,559.10 $386,558.19 $385,550.62 $384,536.32 $383,515.27 $382,487.41 $381,452.69 $380,411.08 379,362.52 $378,306.97 $377,244.39 $376,174.72 $375,097.92 $374,013.94 $372.922.74 $371,824.26 $370,718.46 $369,605.28 $368,484.68 $367,356.62 $366.221.03 S365,077.87 $363,927.09 $362,768.64 $361,502.47 $360,428.52 $359,246.75 $358,057.10 $356,859.51 $355,653.94 $354, 440.34 $353,218.64 $351,988.80 $350,750.77 $349,504.47 $348,249.87 $346,986.91 $345,715.52 $344,435.66 $2,583.73 $2,577.05 $2,570.34 $2,563.58 $2,556.77 $2,549.92 $2,543.02 $2,536.07 $2,529.08 $2,522.05 $2,514.96 $2,507.83 $2,500.65 $2,493.43 $2,486.15 $2,478.83 $2,471.46 $2,464.04 $2,456.56 $2,449.04 $2,441.47 $2,433.85 $2,426.18 $2,418.46 $2,410.68 $2,402.86 $2,394.98 52.387.05 $2,379.06 $2,371.03 $2,362.94 2.354.79 $2,346.59 $2,338.34 $2,330.03 $2,321.57 $2,313.25 $2,304.77 $2,296.24 $1,000.90 $1,007.58 $1,014.29 $1,021.06 $1,027.86 $1,034.72 $1,041.61 $1,048.56 $1,055.55 $1,062.58 $1,069.67 $1,076.80 $1,083.98 $1,091.20 $1,098.48 $1,105.80 $1,113.17 $1,120.60 $1,128.07 $1,135.59 $1,143.16 $1,150.78 $1,158.45 $1,166.17 $1,173.95 $1,181.77 $1,189.65 $1,197.58 $1,205.57 $1,213.60 $1,221.70 $1,229.84 $1,238.04 $1,246.29 $1,254.60 $1,262.97 $1,271.39 $1,279.86 $1,288.39 $386,558.19 $385,550.62 $384,536.32 $383,515.27 $382.487.41 $381,452.69 $380,411.08 $379362.52 $378,306.97 5377,244.39 $376.174.72 $375,097.92 $374,013.94 $372,922.74 371,824.26 $370,718.46 $369,605.28 $368,484.68 $367,356.62 S366.221.03 $365,077.87 S363,927.09 $362,768.64 S361,602.47 $360,428.52 $359,246.75 $358,057.10 5356,859.51 S355,653.94 $354,440.34 $353,218.64 $351,988.80 $350,750.77 $349,504.47 $348,249.87 $346,986.91 5345.715.52 $344,435.66 $343.147.27