Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. solve with excel functions: a certain construction

SOLVE WITH EXCEL FUNCTIONS: A certain construction project, which is expected to take 3 years, will...

70.2K

Verified Solution

Question

Finance

SOLVE WITH EXCEL FUNCTIONS: A certain construction project, whichis expected to take 3 years, will require the first month of $50,000 increasing at a rate of $ 5,000 per month during the first 6months. Then, for 1.5 years, the cash requirements will increase ata rate of 12% per month, taking into account the amount required inmonth 6. The last 12 months, these amounts would decrease at a rateof $ 25,000 per month. Assuming that the project begins to be soldfrom the first month of construction, and would be sold at 100% atthe end of the construction, what should be the average quarterlyincome to cover costs with a 24% return?

Answer & Explanation Solved by verified expert
4.4 Ratings (865 Votes)
MonthsCost15000000255000003600000046500000570000006750000078400000894080009 1053696010 1180139511 1321756312 1480367013    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Psychology
1.2K views

The bystander effect captures a shadowy side of human nature. It may have contributed to atrocities...

Biology
1.2K views

and transplanted them in mouse 3 which had been thymectomized and lethally irradiated no T...

Physics
1.2K views

If current is doubled the deflection is also 14 f doubled in aga 1 Tangent...

Basic Math
1.2K views

Write any fractions like this 5 2pi Here is the graph of a sin wave...

Basic Math
1.2K views

What is the equation for g, which is f(x) = 2x2 + 3x - 1reflected...

Statistics
1.2K views

Suppose one would like to construct a 99 confidence interval for a sample mean when...

Statistics
1.2K views

a Define the hypergeometric random variable and explain briefly 10 P b The components of...

Accounting
1.2K views

Campbell Inc. produces and sells outdoor equipment. On July 1, Year 1, Campbell issued $25,000,000...

Accounting
1.2K views

The keystone of the entire budgeting process is: The sales forecast The purchase budget The...

Accounting
1.2K views

Preparing Financial Statements The adjusted trial balance of Monona Inc. as of December 31 follows....

Finance
1.2K views

Sure Value Hardware has four employees who are paid on an hourly basis, plus time...

Finance
1.2K views

Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's...