Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Calculate in excel... Show formula calculation in excel and answer the 2 questions... CONSTRUCTION DRAW SCHEDULE Assume that a construction budget is $ 9

Please Calculate in excel... Show formula calculation in excel and answer the 2 questions... CONSTRUCTION DRAW SCHEDULE
Assume that a construction budget is $9,704,500. A construction lender is willing to fund up to 80% of this amount including interest charges. The first four draw requests are $1,557,938 each excluding interest. The next four draw requests are $259,656 excluding interest. All draw requests are at the beginning of each month. The annual interest rate is 12% determined on a monthly basis which is added to the outstanding loan amount.
1. What is the cumulative amount of interest accrued over the period?
2. Does the lender exceed his 80% threshold?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Cost Control

Authors: Daniel Traster

1st Edition

0132156555, 978-0132156554

More Books

Students also viewed these Accounting questions

Question

3. Housekeeping, such as watering plants or storing personal items

Answered: 1 week ago