• Welcome to AppraisersForum.com, the premier online  community for the discussion of real estate appraisal. Register a free account to be able to post and unlock additional forums and features.
Status
Not open for further replies.

mdlions16

Freshman Member
Joined
Oct 10, 2019
Professional Status
Appraiser Trainee
State
Arizona
Hello all,

I would really appreciate some help. I am currently working on the excel test in order to register for MAI courses and I am having some issues. I know that I am generating the correct answers because I am checking all the work with a calculator. I am using all the formulas that they are asking me to use, I do not know what to do.

Any help would be much appreciated.
 

Attachments

  • excel test.jpg
    excel test.jpg
    30 KB · Views: 38

PL1957

Senior Member
Joined
Jul 19, 2004
Professional Status
Certified General Appraiser
State
Illinois
Hello all,

I would really appreciate some help. I am currently working on the excel test in order to register for MAI courses and I am having some issues. I know that I am generating the correct answers because I am checking all the work with a calculator. I am using all the formulas that they are asking me to use, I do not know what to do.

Any help would be much appreciated.
I STRONGLY suggest you take an Excel class before you sign up for the MAI classes. You don't want to be confused by the program when trying to learn new concepts. There's a bunch of training available on line or at various adult education/community college settings.
 

Meandering

Elite Member
Joined
Feb 26, 2006
Professional Status
Real Estate Agent or Broker
State
Pennsylvania
Hello all,

I would really appreciate some help. I am currently working on the excel test in order to register for MAI courses and I am having some issues. I know that I am generating the correct answers because I am checking all the work with a calculator. I am using all the formulas that they are asking me to use, I do not know what to do.

Any help would be much appreciated.

Do you have any experience working with excel?

What version of excel do you have?

I have some of these formulas and worksheets in excel 2010
 

Elliott

Elite Member
Joined
Apr 23, 2002
Professional Status
Certified General Appraiser
State
Oregon
Here are some hints:

=Something Economic Life/Some other factor Economic Life



1570763083569.png


There are other 'functions' which deal with some of the other issues, other questions can be answered with creating an algebraic equation. So easy, it does all the math for you.

Hope that helps. 1570763083569.png
 

mdlions16

Freshman Member
Joined
Oct 10, 2019
Professional Status
Appraiser Trainee
State
Arizona
Do you have any experience working with excel?

What version of excel do you have?

I have some of these formulas and worksheets in excel 2010
Yes, I have plenty of experience working with excel. I have excel for mac. I continue to use the pre-programmed formulas that they say they want, but I guess different formulas are wanted because I am doing everything that they want
 

mdlions16

Freshman Member
Joined
Oct 10, 2019
Professional Status
Appraiser Trainee
State
Arizona
I STRONGLY suggest you take an Excel class before you sign up for the MAI classes. You don't want to be confused by the program when trying to learn new concepts. There's a bunch of training available on line or at various adult education/community college settings.
At this point, I would but the class is not being offered anywhere at this time
 

Thomas Holding

Junior Member
Joined
Jan 22, 2004
Professional Status
Certified General Appraiser
State
North Carolina
One of the best exercises you can do is to enter the formulas for the Six Functions of $1. Start with the complete formulas. As you build your formulas to solve more complex problems like finding a discounted value, you will build on your understanding of how each function is interrelated to the others.
 

Attachments

  • dcf formulas.JPG
    dcf formulas.JPG
    149.3 KB · Views: 6
  • dcf no formulas.JPG
    dcf no formulas.JPG
    106.1 KB · Views: 5

Thomas Holding

Junior Member
Joined
Jan 22, 2004
Professional Status
Certified General Appraiser
State
North Carolina
Six functions six functions no formulas.JPG
 

Attachments

  • six function formulas.JPG
    six function formulas.JPG
    101.8 KB · Views: 10
Last edited:
Status
Not open for further replies.
Find a Real Estate Appraiser - Enter Zip Code

Copyright © 2000-, AppraisersForum.com, All Rights Reserved
AppraisersForum.com is proudly hosted by the folks at
AppraiserSites.com
Top

AdBlock Detected

We get it, advertisements are annoying!

Sure, ad-blocking software does a great job at blocking ads, but it also blocks useful features of our website. For the best site experience please disable your AdBlocker.

I've Disabled AdBlock
No Thanks