statistics

clmttcsenl432
Home>Homework Answsers>Mathematics homework help>Algebra homework help
  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.                 
  The Amortization Schedule below has been generated for your use in this assignment and in future professional/personal endeavors.                  
  NOTE: Payment is calculated by using the PMT function in Excel, based on a given interest rate, total periods, present value borrowed (-), and future value                 
                            
  Question 1: NEWS would like to compare two different parcels, each of which is tied to a specific lender and the lender's terms.                  
  Parcel GREEN has the following conditions: Cost = $ 10,000,000; Annual Interest Rate = 11%; Loan Term = 25 Years                   
  Parcel BLUE has the following conditions: Cost = $ 7,500,000; Annual Interest Rate = 20%; Loan Term = 15 Years                   
  Provide your recommendation on which option is the best option and why.                       
  ANSWER:                 
                 
                 
  Question 2: How does your answer change if NEWS is concerned with short-term profit margins?                     
  How does your answer change if NEWS is concerned with long-term debt, due to a poor book value rating from the most recent stock analyst?                 
  ANSWER:                 
                 
                 
                 
                            
  Amount Borrowed (Present Value)       Amount Borrowed (Present Value)                     
  Future Value  $                        -       Future Value  $                    -                     
  Years       Years                     
  Payments per Year 12     Payments per Year 12                   
  Total Periods 0     Total Periods 0                   
  Annual Interest Rate       Annual Interest Rate                     
  Compound Rate 0.00%     Compound Rate 0.00%                   
  Payment Amount #NUM!     Payment Amount #NUM!                   
                            
  Payment Number Payment Interest  Principal  Balance   Payment Number Payment Interest  Principal  Balance                 
                       1#NUM! $                   -  #NUM!#NUM!                       1#NUM! $                  -  #NUM!#NUM!                
                       2#NUM!#NUM!#NUM!#NUM!                       2#NUM!#NUM!#NUM!#NUM!                
                       3#NUM!#NUM!#NUM!#NUM!                       3#NUM!#NUM!#NUM!#NUM!                
                       4#NUM!#NUM!#NUM!#NUM!                       4#NUM!#NUM!#NUM!#NUM!                
                       5#NUM!#NUM!#NUM!#NUM!                       5#NUM!#NUM!#NUM!#NUM!                
                       6#NUM!#NUM!#NUM!#NUM!                       6#NUM!#NUM!#NUM!#NUM!                
                       7#NUM!#NUM!#NUM!#NUM!                       7#NUM!#NUM!#NUM!#NUM!                
                       8#NUM!#NUM!#NUM!#NUM!                       8#NUM!#NUM!#NUM!#NUM!                
                       9#NUM!#NUM!#NUM!#NUM!                       9#NUM!#NUM!#NUM!#NUM!                
                     10#NUM!#NUM!#NUM!#NUM!                     10#NUM!#NUM!#NUM!#NUM!                
                     11#NUM!#NUM!#NUM!#NUM!                     11#NUM!#NUM!#NUM!#NUM!                
                     12#NUM!#NUM!#NUM!#NUM!                     12#NUM!#NUM!#NUM!#NUM!                
                     13#NUM!#NUM!#NUM!#NUM!                     13#NUM!#NUM!#NUM!#NUM!                
                     14#NUM!#NUM!#NUM!#NUM!                     14#NUM!#NUM!#NUM!#NUM!                
                     15#NUM!#NUM!#NUM!#NUM!                     15#NUM!#NUM!#NUM!#NUM!                
                     16#NUM!#NUM!#NUM!#NUM!                     16#NUM!#NUM!#NUM!#NUM!                
                     17#NUM!#NUM!#NUM!#NUM!                     17#NUM!#NUM!#NUM!#NUM!                
                     18#NUM!#NUM!#NUM!#NUM!                     18#NUM!#NUM!#NUM!#NUM!                
                     19#NUM!#NUM!#NUM!#NUM!                     19#NUM!#NUM!#NUM!#NUM!                
                     20#NUM!#NUM!#NUM!#NUM!                     20#NUM!#NUM!#NUM!#NUM!                
                     21#NUM!#NUM!#NUM!#NUM!                     21#NUM!#NUM!#NUM!#NUM!                
                     22#NUM!#NUM!#NUM!#NUM!                     22#NUM!#NUM!#NUM!#NUM!                
                     23#NUM!#NUM!#NUM!#NUM!                     23#NUM!#NUM!#NUM!#NUM!                
                     24#NUM!#NUM!#NUM!#NUM!                     24#NUM!#NUM!#NUM!#NUM!                
                     25#NUM!#NUM!#NUM!#NUM!                     25#NUM!#NUM!#NUM!#NUM!                
                     26#NUM!#NUM!#NUM!#NUM!                     26#NUM!#NUM!#NUM!#NUM!                
                     27#NUM!#NUM!#NUM!#NUM!                     27#NUM!#NUM!#NUM!#NUM!                
                     28#NUM!#NUM!#NUM!#NUM!                     28#NUM!#NUM!#NUM!#NUM!                
                     29#NUM!#NUM!#NUM!#NUM!                     29#NUM!#NUM!#NUM!#NUM!                
                     30#NUM!#NUM!#NUM!#NUM!                     30#NUM!#NUM!#NUM!#NUM!                
                     31#NUM!#NUM!#NUM!#NUM!                     31#NUM!#NUM!#NUM!#NUM!                
                     32#NUM!#NUM!#NUM!#NUM!                     32#NUM!#NUM!#NUM!#NUM!                
                     33#NUM!#NUM!#NUM!#NUM!                     33#NUM!#NUM!#NUM!#NUM!                
                     34#NUM!#NUM!#NUM!#NUM!                     34#NUM!#NUM!#NUM!#NUM!                
                     35#NUM!#NUM!#NUM!#NUM!                     35#NUM!#NUM!#NUM!#NUM!                
                     36#NUM!#NUM!#NUM!#NUM!                     36#NUM!#NUM!#NUM!#NUM!                
                     37#NUM!#NUM!#NUM!#NUM!                     37#NUM!#NUM!#NUM!#NUM!                
                     38#NUM!#NUM!#NUM!#NUM!                     38#NUM!#NUM!#NUM!#NUM!                
                     39#NUM!#NUM!#NUM!#NUM!                     39#NUM!#NUM!#NUM!#NUM!                
                     40#NUM!#NUM!#NUM!#NUM!                     40#NUM!#NUM!#NUM!#NUM!                
                     41#NUM!#NUM!#NUM!#NUM!                     41#NUM!#NUM!#NUM!#NUM!                
                     42#NUM!#NUM!#NUM!#NUM!                     42#NUM!#NUM!#NUM!#NUM!                
                     43#NUM!#NUM!#NUM!#NUM!                     43#NUM!#NUM!#NUM!#NUM!                
                     44#NUM!#NUM!#NUM!#NUM!                     44#NUM!#NUM!#NUM!#NUM!                
                     45#NUM!#NUM!#NUM!#NUM!                     45#NUM!#NUM!#NUM!#NUM!                
                     46#NUM!#NUM!#NUM!#NUM!                     46#NUM!#NUM!#NUM!#NUM!                
                     47#NUM!#NUM!#NUM!#NUM!                     47#NUM!#NUM!#NUM!#NUM!                
                     48#NUM!#NUM!#NUM!#NUM!                     48#NUM!#NUM!#NUM!#NUM!                
                     49#NUM!#NUM!#NUM!#NUM!                     49#NUM!#NUM!#NUM!#NUM!                
                     50#NUM!#NUM!#NUM!#NUM!                     50#NUM!#NUM!#NUM!#NUM!                
                     51#NUM!#NUM!#NUM!#NUM!                     51#NUM!#NUM!#NUM!#NUM!                
                     52#NUM!#NUM!#NUM!#NUM!                     52#NUM!#NUM!#NUM!#NUM!                
                     53#NUM!#NUM!#NUM!#NUM!                     53#NUM!#NUM!#NUM!#NUM!                
                     54#NUM!#NUM!#NUM!#NUM!                     54#NUM!#NUM!#NUM!#NUM!                
                     55#NUM!#NUM!#NUM!#NUM!                     55#NUM!#NUM!#NUM!#NUM!                
                     56#NUM!#NUM!#NUM!#NUM!                     56#NUM!#NUM!#NUM!#NUM!                
                     57#NUM!#NUM!#NUM!#NUM!                     57#NUM!#NUM!#NUM!#NUM!                
                     58#NUM!#NUM!#NUM!#NUM!                     58#NUM!#NUM!#NUM!#NUM!                
                     59#NUM!#NUM!#NUM!#NUM!                     59#NUM!#NUM!#NUM!#NUM!                
                     60#NUM!#NUM!#NUM!#NUM!                     60#NUM!#NUM!#NUM!#NUM!                
                     61#NUM!#NUM!#NUM!#NUM!                     61#NUM!#NUM!#NUM!#NUM!                
                     62#NUM!#NUM!#NUM!#NUM!                     62#NUM!#NUM!#NUM!#NUM!                
                     63#NUM!#NUM!#NUM!#NUM!                     63#NUM!#NUM!#NUM!#NUM!                
                     64#NUM!#NUM!#NUM!#NUM!                     64#NUM!#NUM!#NUM!#NUM!                
                     65#NUM!#NUM!#NUM!#NUM!                     65#NUM!#NUM!#NUM!#NUM!                
                     66#NUM!#NUM!#NUM!#NUM!                     66#NUM!#NUM!#NUM!#NUM!                
                     67#NUM!#NUM!#NUM!#NUM!                     67#NUM!#NUM!#NUM!#NUM!                
                     68#NUM!#NUM!#NUM!#NUM!                     68#NUM!#NUM!#NUM!#NUM!                
                     69#NUM!#NUM!#NUM!#NUM!                     69#NUM!#NUM!#NUM!#NUM!                
                     70#NUM!#NUM!#NUM!#NUM!                     70#NUM!#NUM!#NUM!#NUM!                
                     71#NUM!#NUM!#NUM!#NUM!                     71#NUM!#NUM!#NUM!#NUM!                
                     72#NUM!#NUM!#NUM!#NUM!                     72#NUM!#NUM!#NUM!#NUM!                
                     73#NUM!#NUM!#NUM!#NUM!                     73#NUM!#NUM!#NUM!#NUM!                
                     74#NUM!#NUM!#NUM!#NUM!                     74#NUM!#NUM!#NUM!#NUM!                
                     75#NUM!#NUM!#NUM!#NUM!                     75#NUM!#NUM!#NUM!#NUM!                
                     76#NUM!#NUM!#NUM!#NUM!                     76#NUM!#NUM!#NUM!#NUM!                
                     77#NUM!#NUM!#NUM!#NUM!                     77#NUM!#NUM!#NUM!#NUM!                
                     78#NUM!#NUM!#NUM!#NUM!                     78#NUM!#NUM!#NUM!#NUM!                
                     79#NUM!#NUM!#NUM!#NUM!                     79#NUM!#NUM!#NUM!#NUM!                
                     80#NUM!#NUM!#NUM!#NUM!                     80#NUM!#NUM!#NUM!#NUM!                
                     81#NUM!#NUM!#NUM!#NUM!                     81#NUM!#NUM!#NUM!#NUM!                
                     82#NUM!#NUM!#NUM!#NUM!                     82#NUM!#NUM!#NUM!#NUM!                
                     83#NUM!#NUM!#NUM!#NUM!                     83#NUM!#NUM!#NUM!#NUM!                
                     84#NUM!#NUM!#NUM!#NUM!                     84#NUM!#NUM!#NUM!#NUM!                
                     85#NUM!#NUM!#NUM!#NUM!                     85#NUM!#NUM!#NUM!#NUM!                
                     86#NUM!#NUM!#NUM!#NUM!                     86#NUM!#NUM!#NUM!#NUM!                
                     87#NUM!#NUM!#NUM!#NUM!                     87#NUM!#NUM!#NUM!#NUM!                
                     88#NUM!#NUM!#NUM!#NUM!                     88#NUM!#NUM!#NUM!#NUM!                
                     89#NUM!#NUM!#NUM!#NUM!                     89#NUM!#NUM!#NUM!#NUM!                
                     90#NUM!#NUM!#NUM!#NUM!                     90#NUM!#NUM!#NUM!#NUM!                
                     91#NUM!#NUM!#NUM!#NUM!                     91#NUM!#NUM!#NUM!#NUM!                
                     92#NUM!#NUM!#NUM!#NUM!                     92#NUM!#NUM!#NUM!#NUM!                
                     93#NUM!#NUM!#NUM!#NUM!                     93#NUM!#NUM!#NUM!#NUM!                
                     94#NUM!#NUM!#NUM!#NUM!                     94#NUM!#NUM!#NUM!#NUM!                
                     95#NUM!#NUM!#NUM!#NUM!                     95#NUM!#NUM!#NUM!#NUM!                
                     96#NUM!#NUM!#NUM!#NUM!                     96#NUM!#NUM!#NUM!#NUM!                
                     97#NUM!#NUM!#NUM!#NUM!                     97#NUM!#NUM!#NUM!#NUM!                
                     98#NUM!#NUM!#NUM!#NUM!                     98#NUM!#NUM!#NUM!#NUM!                
                     99#NUM!#NUM!#NUM!#NUM!                     99#NUM!#NUM!#NUM!#NUM!                
                   100#NUM!#NUM!#NUM!#NUM!                   100#NUM!#NUM!#NUM!#NUM!                
                   101#NUM!#NUM!#NUM!#NUM!                   101#NUM!#NUM!#NUM!#NUM!                
                   102#NUM!#NUM!#NUM!#NUM!                   102#NUM!#NUM!#NUM!#NUM!                
                   103#NUM!#NUM!#NUM!#NUM!                   103#NUM!#NUM!#NUM!#NUM!                
                   104#NUM!#NUM!#NUM!#NUM!                   104#NUM!#NUM!#NUM!#NUM!                
                   105#NUM!#NUM!#NUM!#NUM!                   105#NUM!#NUM!#NUM!#NUM!                
                   106#NUM!#NUM!#NUM!#NUM!                   106#NUM!#NUM!#NUM!#NUM!                
                   107#NUM!#NUM!#NUM!#NUM!                   107#NUM!#NUM!#NUM!#NUM!                
                   108#NUM!#NUM!#NUM!#NUM!                   108#NUM!#NUM!#NUM!#NUM!                
                   109#NUM!#NUM!#NUM!#NUM!                   109#NUM!#NUM!#NUM!#NUM!                
                   110#NUM!#NUM!#NUM!#NUM!                   110#NUM!#NUM!#NUM!#NUM!                
                   111#NUM!#NUM!#NUM!#NUM!                   111#NUM!#NUM!#NUM!#NUM!                
                   112#NUM!#NUM!#NUM!#NUM!                   112#NUM!#NUM!#NUM!#NUM!                
                   113#NUM!#NUM!#NUM!#NUM!                   113#NUM!#NUM!#NUM!#NUM!                
                   114#NUM!#NUM!#NUM!#NUM!                   114#NUM!#NUM!#NUM!#NUM!                
                   115#NUM!#NUM!#NUM!#NUM!                   115#NUM!#NUM!#NUM!#NUM!                
                   116#NUM!#NUM!#NUM!#NUM!                   116#NUM!#NUM!#NUM!#NUM!                
                   117#NUM!#NUM!#NUM!#NUM!                   117#NUM!#NUM!#NUM!#NUM!                
                   118#NUM!#NUM!#NUM!#NUM!                   118#NUM!#NUM!#NUM!#NUM!                
                   119#NUM!#NUM!#NUM!#NUM!                   119#NUM!#NUM!#NUM!#NUM!                
                   120#NUM!#NUM!#NUM!#NUM!                   120#NUM!#NUM!#NUM!#NUM!                
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
  • 10 years ago
  • 20
Report issue
Answer(1)
WiseOne
4.2 (16)
5.0 (2)
Chat

Purchase the answer to view it

  • amortization_excel_assignment.xls
Bids(1)