please help with this tab

Formatting Styles Table Styles Clipboard Font Alignment Number Editing V30 B C D E F G H I McCormick & Company is considering building a new factory in largo, Maryland. James Frands, a landowner, is selling a 4,35-acre parcel of industrial zoned land with a sted sale price of $3,000,000.00 for the land. McCormick & Company is interested in the land and so is another manufacturing company. The competing manufacturing company has made a full offer of $3,000,000.00 for the land. McCormick & Company knows it can make an offer to outbid the competitor to obtain the land. So, McCormick & Company decided to offer $4,424,000.00 Now, the Landowner must make a decision between the two competing offers. To make this decision, James should first identify the Future Value (PV) of each offer. James's bank is offering a 12 percent interest rate when invested through the bank managed growth stock portfolios. Let's help James make his decision by answering the following questions using the template to the right 1. What is the Future Value (FV) of each offer? 13 2. Based on your Future Value calculations, which offer should lames accept? Principal Percent Down Amount 15 McCormick & Company has decided in order for the company to have a minimal impact on current cashews, the company will need to 16 borrow 70 percent Loan to Value (LTV) of the $4,424,000.00 offer in the form of a commercial acquisition and development loan to 17 purchase the land. This means McCormick & Company will need to make a 30 percent down payment to secure the commercial 10 acquisition and development loan. McCormick & Company is considering three different loan options: 1/Y PV Loan A: 20 year loan with a fixed annual interest rate of 6 percent Loan : 10-year loan with a fixed annual interest rate of 45 percent Loan C 15 year loan with a fixed annual interest rate of 5 percent Loan loan c N w PV PMI ANNER Loan Loan A 23 3. How much of the total $4,424,000.00 offer will be financed? 25 4. Which loan will have the lowest monthly payment? 27 S Which loan will have the lowest total payback amount? 29 6. Would you recommend McCormick & Company select the loan with lowest monthly payment or lowest total payment and why? Instructions Financing and Investing Corporate Valuation Annuities O Type here to search DB e Le