Answer:
5.84%
Explanation:
We use the RATE function that is shown in the excel. Kindly find the attachment below:
The NPER shows the time period.
Given that,
Present value = $45
Future value or Face value = $47
PMT = $2
NPER = 3
The formula is shown below:
= Rate(NPER,PMT,-PV,FV,type)
So, the annual compound rate of return is 5.84%
Answer:
A
Explanation:
This is because it allows the respondent indicate the intensity of his or her feelings by using the agree-disagree response continuum position according to the Likert survey rating scale.
Answer:
73 months
approximately 6 years
Explanation:
The period of time it would take to pay off the loan can be determined using excel nper function as below:
=nper(rate,pmt,-pv,fv)
rate is the interest expressed in monthly terms which is 15.3%/12
pmt is the amount payment per month i.e $90
pv is the amount of loan which is $4250
fv is the balance of the loan after all payments have been made i.e $0
=nper(15.3%/12,90,-4250,0)= 73 months
73 months/12 months=approximately 6 years
Answer:
C. farmers would not be able to sell all their wheat.
Explanation:
At a price of $4, quantity supplied exceeds quantity demanded. Quantity supplied is 73 while quantity demanded is 50. There is an excess supply over demand. Therefore, farmers would not be able to sell all their wheat.
Equilibrium price is $2. This is where quantity supplied equals quantity demanded.
I hope my answer helps you