What will be the future value of selling books at their Original Price in 6 years if the interest rate is 3%.

In sheet1,
Suppose there is a bookstore that has 100 books in storage. The unique price of the book is 250 and a certain number of books are sold at that price. Later, the bookstore
introduced a 10% discount on that book and cleared off the stock. You might need to realize:
1- How many books are sold at the original price to obtain a total revenue of 24,500;
2- What will be the future value of selling books at their Original Price in 6 years if the interest rate is 3%;
In sheet2,
The human resource department plans to pay a bonus based on personnel’s monthly appraisal scores. Each individual’s data including personal ID, Department, and personal
Appraisal Score is recorded in Table1, data regarding each department’s appraisal score is recorded in table2 and each individual’s monthly salary is recorded in Table3.
There is a model to calculate each individual’s Final Appraisal Payment. Based on this model, if a department’s appraisal score is less than 50%, no one in that department
will receive the bonus money. If the appraisal score is greater than 50%, the average of Department Appraisal Score and Personal Appraisal Score will be considered as Final
Appraisal Score.
Final Appraisal Payment will be then calculated as the multiplication of Monthly Salary and Final Appraisal Score.
3- You are required to fill relevant columns in Table1 and calculate “Final Appraisal Payment” based on the described appraisal model;
4- Use conditional formatting to show Personal Appraisal Score greater than 50% with Green;
5- Insert a row and find the summation of Total Final Appraisal Payment;

Last Completed Projects