Monthly Cash Flow Report including Debt Schedule.As a continuation of the Land Development Anywhere USA case study, this assignment provides the final three components. Monthly Cash Flow Report including Debt Schedule

Monthly Cash Flow Report including Debt Schedule.As a continuation of the Land Development Anywhere USA case study, this assignment provides the final three components.
Monthly Cash Flow Report including Debt Schedule

Expected time to complete: 12-24 hours

As a continuation of the Land Development Anywhere USA case study, this assignment provides the final three components. The three separate assignments should be completed sequentially.

1. The first assignment requires preparing a monthly cash flow report using uniform and normal cash flow distributions. This will require adding four worksheets including the Cash Flow Report, a Project Schedule, Hard Cost Schedule, and Soft Cost Schedule.

Objectives:

This assignment requires you to read Preparing a Monthly Project Cash Flow Report for Land Development Anywhere USA.

o Apply reading and lecture

o Practice using learned Excel skills

o Create multiple worksheets involving numerous Excel functions

Methodology:

Using the information calculated in the prior assignments, complete the cash flow reports. This exercise will require formatting, entering formulas, and analyzing results.

Assignment

Important Instructions: Read these instructions carefully. I will not accept any assignment which does not follow these instructions.

This assignment is intended to reinforce the learning of methods to calculate development potential for residential and commercial real estate.

READ THE DESCRIPTION CAREFULLY.

In the Land Development Anywhere USA workbook, add two new worksheets properly labeled (including tabs). One worksheet should be labeled Monthly Cash Flow and the second worksheet should be labeled Debt Schedule. Each worksheet should be prepared to print on one sheet tall (printed in landscape format) each using applicable Excel formula and references. You will be required to completely prepare the worksheet to be identical to the solutions that are provided.

Remember to “follow the code” so each page of the workbook is properly formatted with relevant information such as header, footer, and page numbers. Use highlighting, bolding, and other formatting tools to emphasize answers. Remember, your boss (me) is very busy so make sure your workbook is concise, easy to ready with complete information.

Page 2 of 33

Provide the electronic and printed copy of the entire workbook before the final exam. Staple multiple pages. Eleven (11%) percent of the grade on this project is based on proper formatting. The balance of the grade is based on the accuracy of the solution.

Explanation & Answer

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.