Having trouble with question 1 and 2.

Question 1: NEWS would like to compare two different parcels, each of which is tied to a specific lender and the lender's terms. Provide your recommendation on which option is the best and support your recommendation.

Question 2: Explain how your answer might change if NEWS was concerned with short-term profit margins. Explain how would your answer might change if NEWS is concerned with long-term debt, due to a poor book value rating from the most recent stock analysis?

mba501 excel template-6-2 tw5 (1)xs Excel DRAWING TOOLS Nyles Moye* HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VIEW FORMAT | TextBox 2 2 NEWS has decided to purchase a new parcel of land in order to expand operations into a brand-new facility and retake the competitive advantage 3 The Amortization Schedule below has been generated for your use in this assignment and in future professional/personal endeavors NOTE: Enter the information presented in Tasks 1 and 2. No calculations are needed to generate values in the tables below Task 1: Parcel GREEN 7 Step 1: Enter the following information into the highlighted cells associated with the green parcel section below: 8 Cost $10,000,000 9 Annual Interest Rate-11% (NOTE: enter this as a whole number and not a decimal) 10 Loan Term-25 Years Task 2: Parcel BLUE 12 13 Step 1: Enter the following information into the highlighted cells associated with the blue parcel section below 4 Cost-7,500,000 15 Annual Interest Rate = 20% (NOTE: enter this as a whole number and not a decimal) 16 Loan Term-15 Years 17 18 Question 1: NEWS would like to compare two different parcels, each of which is tied to a specific lender and the lender's terms. Provide your recommendation on which option is the best and support your recommendation 19 20Answer 23 24 Question 2: Explain how your answer might change if NEWS was concerned vith short term profit margins. Explain how would your answer might change if NEWS is oncerned with long-term debt, due to a poor book value rating from the r ecent stock analysis? 2T |Answer Introduction Template Amortization +80% 1:28 PM 4/20/2019 O Type here to search ^ mba501 excel template-6-2 tw5 (1)xs Excel DRAWING TOOLS Nyles Moye HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VIEW FORMAT TextBox 2 X Parcel GREEN Parcel BLUE 33 Borowed10,000,000.00 Borrowed $7.500,000.00 34 Value S Years Payments r Year Total Years r Year Total Periods 37 Periods 20.00 Interest Rate Compound Rate 0 92% 1 67% Rate Payment Payment$131,722.24 S98,011.31 Payment Interest Principal Balance Interest Principal Balance Number S98,011.31$ 91,666.67$6,344.64 $9,993,655.36 $98,011.31 $ 91,608.51 $ 6,402.80 $9,987,25256 $98,011.31 $ 91,549.82 $ 6,461.49 $9,980,791.0 $98,011.31 $ 91,490.58 $ 6,520.72 $9,974,270.34 $98,011.31 $ 91,430.81 $ 6,580.50 $9,967,689.85 $98,011.31 $ 91,370.49 $ 6,640.82 $9,961,049.03 $98,011.31 $ 91,309.62 $ 6,701.69 $9,954,347.34 $98,011.31$ 91,248.18 $ 6,763.12 $9,947,584.2 $98,011.31 $ 91,186.19 $ 6,825.12 $9,940,759.10 $98,011.31$ 91,123.63 $ 6,887.68 $9,933,871.41 $98,011.31 $ 91,060.49 $ 6,950.82 $9,926,920.59 $98,011.31$ 90,996.77 $ 7,014.54 $9,919,906.06 $98,011.31$ 90,932.47 $ 7,078.84 $9,912,827.22 s98 011 31 sanRG7 58s; 7143 S9905 6 3 50.- |--14 1 $131,722.24 $ 125,000.00 $6,722.24S 2 $131,722.24 $124,887.96 $6,834.28S 3 $131,722 24 $124,774.06 $6,948.18S 4 $131,722.24 $124,658.26 $7,063.98S 5 $131,722.24 $124,540.52 $7,181.72 S 6 $131,722.24 $ 124,420.83 $7,301.41 S 7 $131,722 24 $124,299.14 $7,423.10 S 8 $131,722.24 $124,175.42 $7 546.82 S 9 $131,722 24 $124,049.64 $7,672.60 S 10 $131,722 24 $123,921.76$7,800.48 S 11 $131,722 24 $123,791.75 $7,930.48S 12 $131,722 24 $123,659.58 $8,062.66 S 13 $131,722 24 $123,525.20 $8,197.04S $131 722 24$,123 38 58, $8333 6 7,493,277.76 ,486,443.49 7,479,495.31 ,472,431.33 ,465,249.61 ,457,948.20 450,525.10 ,442,978.28 7,435,305.68 ,427,505.20 7,419,574.72 7,411,512.06 7,403,315.02 394 9R13 Template - Amortization 1:29 PM O Type here to search mba501 excel template-6-2 tw5 (1)xs Excel HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VIEW $98,011.31 S 87,531.18 $10,480.12 $9,538,376.35 $98,011.31 S 87,435.12 $10,576.19 $9,527,800.16 $98,01131 S 87,338.17 $10,673.14 $9,517,127.02 598,011.31 S 87,240.33 S 10,770.98 $ 9,506,356.04 $98,011.31 S 87,141.60 S 10,869.71 9,495,486.33 $98,011.31 S 87,04196 $10,969.35 $ 9.484,516.98 $98,01131 S 86,94141 $11,069.90 $ 9.473,447 08 598,011.31 S 86,839.93 S 11,171.38 $9,462,275.70 $98,011.31 S 86,737.53 S 11,273.78 9,451,001.92 $98,011.31 S 86,634.18 $11,377.12 $9.439,624.80 $98,01131 S 86,529.89 $11,48141 $9.428,143.38 598,011.31 S 86,424.65 $ 11,586 66 $ 9,416,556.72 $98,011.31 S 86,318.44 $11,692.87 $9,404,863.85 $98,011.31 S 86,211.25 $11,800.06 $9,393,063.80 $98,01131 S 86,103.08$11,908.22 $9,381,155.57 598,011.31 S 85,993.93 S 12,017.38 $ 9,369,138.19 $98,011.31 S 85,883.77 $12,127.54 $9,357,010.65 $98,011.31 S 85,772.60 $12,238.71 $9,344,771.94 $98,01131 85,660 41 $12,350.90 $9,332,42104 598,011.31 S 85,547.19 S 12,464.11 $ 9,319,956.93 $98,011.31 S 85,432.94 $12,578.37 $9,307,378.56 $98,011.31 S 85,317.64 $12,693.67 $9,294,684.89 $98,01131 85,201.28 $12,810.03 $9,281,874 86 98,011.31 $ 85,083.85 $ 12,927.45 $9,268,947.40 $98,011.31 S 84,965.35 $13,045.96 $9,255,901.45 $98,011.31 S 84,845.76$13,165.54 $9,242,735.90 $98,01131 S 84,725.08$13,286.23 $9,229,449.67 98,011.31 $ 84,603.29 $13,408.02 $9,216,041.66 $98,011.31 S 84,480.38 $13,530.93 $9,202,510.73 $98,011.31 S 84,356.35 $13,654.96 $ 9,188,855.77 $98,01131 S 84,231.18$13,780.13 $9,175,075 64 598,011.31 S 84,104.86 $ 13,906 45 $9,161,169.19 $98,011.31 S 83,977.38 S 14,033.92 $9,147,135.27 56 $131,722 24$ 115,036.86$16,685.38 57 $131,722 24$ 114,758.77$16,963.47 58 $131 722 24$ 114,476.05$17,246.19 59 $131,722 24 114,188.61 S17,533.63 60 $131,722 24$ 113,896.38$17,825.85 61 $131,722 24$ 113,599.29 $18,122.95 S 62 $131 722 24$ 113,297.24$18,425.00 63 $131,722 24 $ 112,990.15 S18,732.08 64 $131,722 24$ 112,677.95$19,044.29 65 $131,722 24$ 112,360.55 $19,361.69 66 $131 722 24$ 112.037.85$19,684.39 67 $131,722 24 111,709.78S20,012.46 68 $131,722 24$ 111,376.24$20,346.00 69 $131,722 24$ 111,037.14$20,685. 10S 0 $131 722 24$ 110,692.39$21,029.85 71 $131,722 24 $ 110,341.89 $21,380.35 S 72 $131,722 24$ 109,985.55 $21,736.69 73 $131,722 24$ 109,623.27$22,098.97 74 $131 722 24$ 109,254.96$22,467 28 75 $131,722 24 $ 108,880.50 S22,841.74S 76 $131,722 24$ 108,499.80 $23,222.43 S 77 $131,722 24$ 108,112.76$23,609.47 78 $131 722 24$ 107,719.27$24,002.96 79 $131,722 24$ 107,319.22 $24,403.01 80 $131,722 24$ 106,912.51$24,809.73 81 $131,722 24$ 106.499.01$25,223.23 82 $131 722 24$ 106,078.62$25,643.61 83 $131,722 24 105,651.23 S26,071.01 84 $131,722 24$ 105,216.71$26,505.52 85 $131,722 24$ 104,774.96$26,947.28 S 86 $131 722 24$ 104,325.83$27,396.40 87 $131,722 24 103,869.23 S27,853.01 88 $131,722.24 S 103,405.01 S28,317.23 S mba501 excel template-6-2 tw5 (1)xs Excel HOME INSERT PAGE LAYOUTFORMULAS DATA REVIEW VIEW $98,011.31 S 83,848.74 $14,162.57 $9,132,972.70 $98,011.31 S 83,718.92 S14,292.39 $ 9,118,680.31 $98,01131 S 83,587.90 $14,423.40 $9,104,256.91 598,011.31 S 83,455.69$ 14,555.62 $ 9,089,701.29 $98,011.31 S 83,322.26 $14,689.05 $9,075,012.24 $98,011.31 S 83,187.61 S 14,823.70 $ 9,060,188.55 $98,01131 S 83,051.73$14,959.58 $9,045,228.97 598,011.31 S 82,914.60$ 15,096.71 $9,030,132 26 $98,011.31 S 82,776.21 $15,235.10 $9,014,897.16 $98,011.31 S 82,636.56 $15,374.75 $8,999,522.41 $98,01131 82,495 62 $15,515.69 $8,984,006.73 598,011.31 S 82,353.39$ 15,657.91 $8,968,348.81 $98,011.31 S 82,209.86 $15,801.44 $8,952,547.37 $98,011.31 S 82,065.02 $15,946.29 $ 8,936,601.08 $98,01131 S 81,918.84 $16,09246 $8,920,508.61 598,011.31 S 81,771.33 S 16,239.98 $ 8,904,268.64 $98,011.31 S 81,622.46 $16,388.85 $8,887 ,879.79 $98,011.31 S 81,472.23 $16,539.08 $8,871,340.71 $98,01131 S 81,320.62 $16,690.68 $8,854,650.03 598,011.31 S 81,167.63 S 16,843.68 $8,837,806.35 $98,011.31 S 81,013.22 $16,998.08 $8,820,808.26 $98,011.31 S 80,857.41 $17,153.90 $ 8,803,654.37 $98,01131 S 80,700.17 $17.311.14 $8,786,343.22 598,011.31 S 80,541.48 S 17,469.83 $8,768,873.40 $98,011.31 S 80,381.34 S 17,629.97 8,751,243.43 $98,011.31 S 80,219.73 $17,791.58 $8,733,451.85 $98,01131 S 80,056.64 $17,954.67 $8,715,497.19 598,011.31S 79,892.06 S 18,119.25 $ 8,697,377.94 $98,011.31 S 79,725.96 $18,285.34 $ 8,679,092.59 $98,011.31 S 79,558.35 $18,452.96 $8,660,639.63 $98,01131 $ 79,389.20 $18,622.11 $8,642,017 52 598,011.31S 79,218.49$ 18,792 81 $8,623,224.71 89 $131,722 24$ 102,933.06$28,789.18 90 $131,722 24$ 102.453.24$29,269.00 91 $131 722 24$ 101,96542$29,756.82 92 $131,722 24 101,469.47 S30,252.76 93 $131,722 24$ 100,965.26$30,756.98 94 $131,722 24$ 100.452.64$31,269.59 95 $131 722 24$ 99,93148$31,790.75 96 $131,722 24 $ 99 401.64S32,320.60 97 $131,722 24 $ 98,862.96$32,859.28 918.42 98 $131,722 24$ 98,315.31$33,406.93 99 $131 722 24$ 97,758.52$33,963.71 100 $131,722 24 $ 97,19246 S34,529.77 101 $131,722 24 $ 96,616.97 $35,105.27 102 $131,722 24 $ 96,031.88 $35,690.36S 103 $131,722 24$95,437 04 $36,285.20 104 $131,722 24 $ 94,832.29 S36,889.95S 105 $131,722 24 $ 94,217.45 $37,504.78 106 $131,722 24 $ 93,592.37 $38,129.86 07 $131,722 24$ 92.956.88 $38,765.36 108 $131,722 24 $ 92,310.79 S39411.45 109 $131,722.24$ 91,653.93 $40,068.31 S 110 $131,722 24 $ 90,986.12 $40,736.11 111 $131,722 24$ 90 307 19 $41,415.05 112 $131,722 24$ 89,616.94 S42,105.30 113 $131,722 24 $ 88,915.18 $42,807.05 114 $131,722 24 $ 88,201.73 $43,520.51 115 $131,722 24$ 87 476. 39 $44,245.85 116 $131,722 24$ 86,738.96 544,983.28 117 $131,722 24 $ 85,989.24 $45,733.00 118 $131,722 24 $ 85,227.02 $46,495.22 S 119 $131,722 24 $ 84 452 10 $47,270.14 120 $131,722 24$ 83,664 27 S48,057.97 7,018.00 Introduction Template-Amortization