Question: Year 5 CALCULATIONS (50 POINTS) On the second page, please complete the pro forma using your personal expectations given the following inputs. Also please describe

Year 5 CALCULATIONS (50 POINTS) On the second page, please complete the pro forma using your personal expectations given the following inputs. Also please describe what you think is occurring here based on the information you've been provided. Explain all your assumptions. Assumptions: Rate Year 1 Year 2 Year 3 Year 4 Base Rent Year Over Year Growth 0.00% 2.00% 8.00% 5.00% 0.67% Vacancy Rate % 20.00% 20.00% 0.00% 2.00% 3.00% Credit Loss % Gross income 15.00% 15.00% 2.00% 5.00% 4.00% Expense Year Over Year Growth 0.00% 0.00% 5.00% 4.00% 4.00% Management Fee % Reimbursables Gross Square Footage 1,000,000 Elevators 10% Elevator Lobbies 20% Cell Antenna Partnership $7300 / mo. Lease rents $1.33 / sq. ft. Capitalization Ratio 9.50% California Property Tax 1.10% 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

i just need to complete the excel Frenchies Signature Assignment Joseph Preimesberger posted on Nov 8, 2021 9:35 AM Edited This is a shortened assignment, so just complete the three Excel tabs given...

i just need to know how to do the excel sheets with formulas please. sorry for all of the pictures! im not positive whats important! thank you! this is everything i know Frenchies: Creating and using...

please see attachment for instructions,Only the following budget spreadsheets are to be included: Sales, Collections, and Production. Be sure to use Word Wrapping, Alignment, and Punctuation for...

Frenchies: Creating and Using a Master Budget BACKGROUND Frenchies is a medium-sized regional bakery that specializes in providing orders to grocery and convenience stores. Because of the popularity...

Hello Vjvgoe, I have attacked the template I'm required to use to create the master budget for "Frenchies Prompt". I would need like an initial starting process so I can grasp the information little...

Hello. Can you please help me fill out this excel master budget sheets (all tabs) using the instructions from the pdf attachment? Thank you! Buns Bakery Basic Information For Year Ended December 31,...

Please help me with creating a master budget for Frenchies regional bakery. Attached is the background and excel attachment to. Buns Bakery Basic Information For Year Ended December 31, Year 2 Case...

CALCULATIONS (50 POINTS) On another sheet, complete the pro forma using your personal expectations given the following inputs. Also please describe what you think is occurring here based on the...

Latoya Graham earns a monthly income of $15,500. However, she enjoys swimming and playing netball and she plan to spend $3,500 of her income on both. Information from the market states that to use...

Assume you are in charge of establishing a training program for supervisors in administering discipline. Based on the supervisor's potential role in the disciplinary process, formulate and discuss...

1 ) Burr Oak Malinois Co . ( BOM ) issued callable bonds on January 1 , 2 0 2 1 . BOM's accountant has projected the following amortization schedule from issuance until maturity:Cash...

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".