Skip to content
Home » Admin & Accounting Intern Prepare the following challenge and send your report in Excel to [email protected]

Admin & Accounting Intern Prepare the following challenge and send your report in Excel to [email protected]

Interview challenge

 
 
Pyramidia Ventures

 
 
Interview Challenge – Accounting

 
 
 
 
Admin & Accounting Intern

 
 
 
 
Prepare the following challenge and send your report in Excel to [email protected]

 
 
 
 
You are the Accounts Assistant of Pyramidia Ventues Ltd. You are tasked with preparing the periodic Financial Statements.

 
 
 
 
In any cases where the information is incomplete (indicated with a ?), you’ll have to make and cite your assumptions explicitly.

 
 
 
 
1. Prepare 12-months of monthly financials, from July 2023 to June 2024.

 
 
 
 
2. Prepare an Income statement for the year and Opening and Closing Balance sheet for the end of June 2024.

 
 
 
 
The below information is available. Highlight any concerns or comments

 
 
 
 
 
 
Item
 
Items as of July 2023
%
Assumptions

 
 
 
 
 
 
Sales of Tomatoes
 
Ksh800,000
 
Growing at 5% per month

 
 
 
 
 
 
Sales of Leafy Greens
 
Ksh500,000
 
Growing at 8% per month

 
 
 
 
 
 
Rent of sales branches
 
Ksh10,000
 
Constant monthly

 
 
 
 
 
 
Salaries
 
Ksh150,000
 
Growing by 5,000 every month

 
 
 
 
 
 
Sales & Marketing cost
 
Ksh80,000
 
Growing the same as sales volume growth

 
 
 
 
 
 
Other admin
 
Ksh40,000
 
Growing at 2% monthly

 
 
 
 
 
 
Gross Margin on Tomatoes
 
 
26%
As of January, GM improves to 28%

 
 
 
 
 
 
Gross Margin on Leafy Greens
 
 
24%
As of January, GM improves to 26%

 
 
 
 
 
 
Long-term bank debt
 
Ksh5,000,000
 
5-year term loan with annual principal repayment in January

 
 
 
 
 
 
Interest on debt
 
 
?
Payable monthly. Please suggest interest rate

 
 
 
 
 
 
Purchase of new car
 
?
 
Buy 1 small car in the coming year. Please suggest price and how to finance

 
 
 
 
 
 
Electricity and water
 
Ksh15,000
2%
Monthly bill, rising at 2% per month

 
 
 
 
 
 
Current assets
 
Ksh3,400,000

 
 
 
 
 
 
Current liabilities
 
Ksh500,000

 
 
 
 
 
 
Property, plant & equipment
 
Ksh6,000,000

 
 
 
 
 
 
Accumulated depreciation
 
Ksh900,000

 
 
 
 
 
 
Financial year depreciation
 
Ksh300,000

 
 
 
 
 
 
Stockholder equity
 
Ksh3,000,000

&”Calibri,Regular”&K000000&T_x000D_&D &”Calibri,Regular”&K000000Confidential_x000D_&F &”Calibri,Regular”&K000000Page &P _x000D_of &N

Interested in getting help with this assignment?
Get a professional writing team to work on your assignment!
Order Now
Recent postsFor this final assignment, you will prepare a brief paper detailing the steps undertaken to complete a presentation that disseminates information you assemble
Please choose to answer only one of the 2 following questions. Option 1: In your opinion and based on scientific, peer-reviewed published evidence, does child
At the beginning of the previous academic year, the institution announced it would drop football at the conclusion of the season. The announcement created pub
you will review current research in Personality and provide a critical evaluation of that personality research through an annotated bibliography. An annotated
In Module 5, we considered the third in our three-part series on research design. Specifically, the focus was on the longitudinal studies, in which the resear

Need help with a similar or different Task?

We have the best writers to help you. Hire Writer Now

ORDER NOW