You are a financial analyst working for a real estate company named Cashino, LLC, that is evaluating the purchase of a multi-tenant shopping center named Flamingo Gardens located on Las Vegas Boulevard in Las Vegas, Nevada. You have been asked by the management of Cashino to create a table that summarizes pertinent information on the tenants currently occupying space within Flamingo Gardens. The seller of the center has provided the following information for each space and tenant within the center suite number, tenant name, square footage leased, current monthly rent, and lease expiration date. This information is summarized below: Suite 1; Ralph's Supermarket; 42,500 sqft; $30,000; January 31, 2023 suite 2; VACANT; 12,500 sqft, $0; NA Suite 3; Vegas Nails Salon; 1,500 sqft; $2,000; April 30, 2019 Suite 4; All Night Liquor; 2,400 sqft; $3,000; December 31, 2018 Suite 5; Relax U Massage Parlor; 2,000 sqft; $4,000; March 31, 2019 suite 6; VACANT; 1,300 sqft, $0; NA Suite 7; Blockbuster Video; 3,500 sqft; $5,250; July 31, 2019 Suite 8; It's a Gamble Pizza; 900 sqft; $1,200; May 31, 2019 Suite 9; Apartment Lookout; 2,000 sqft; $3,500; August 31, 2019 Suite 10; Flamingo Center Bar & Grill; 5,600 sqft; $6,000; December 31, 2021 suite 11; VACANT; 1,800 sqft, $0; NA Suite 12; Smoke'em if you Got'em; 2,000 sqft; $3,500; June 30, 2019 From the information summarized above, create a professional looking table that summarizes all of the information above for your management team at Cashino (in the lingo of those in the real estate world, you are creating a simplified "Rent Roll"). Make the table presentable for your readers (use forrnatting items that help your reader and/or make the table look professional) and include the following columns: suite number, tenant name, square footage leased, current monthly rent, and lease expiration date. Be sure to include the vacant suites in your rent roll. You are to also include an extra column that highlights the monthly rent on a per square foot leased basis for each tenant (for example, the per square foot rent for Relax U is $2.00/sqft). At the bottom of the rent roll, you are to provide a grand total of the square footage of the center and the total monthly rent earned by the center. Finally, highlight in some fashion of your choosing those leases that have expired or will expire within by July 31, 2019. In addition to creating the Rent Roll, you will also create two figures: 1) a column/bar chart that presents the tenants of the center and compares their rent per square foot, and 2) a pie chart that shows how the total rent earned by the center breaks down by Tenant. How you visually present your solution to this homework will be a large portion of your grade on this assignment create a rent roll and figures that are easy to read and professional looking. Spend some time working with the different formatting features for both of the figures as well as for the Rent Roll table. Print a formula page for your rent roll as well and turn it in with your solution to this assignment.