Totals at the bottom of abstract module

Memorandum:

To:   All

Thru:  LU

     Attention:   Ms. Gladys

                        Ms. Tina

Date:   February 6 2026

SUBJECT STATUS OF PNL PRESENTATION THIS PM

2626 what an auspicious day

1.  The making of such pnl should be easy if the parties:  SBU were doing the pnl module religiously and correctly and also  Cash Disbursement Book (CBD)  All you have to do are:

     1.  Total the pnl module

          Module one total

         Module three:

            (Total net lot collection  1

             52% VAT, MCF, insurance, collection fee ME)

           x  developers share =

             Developer share

            -  Cogs

                   computation when cash, dp

                    monthly amortization  1, 2, 3, 4, 5 years

              

                

     2.  Total the CDB

     3.  Subtract 2 from 3.

2.  But from what this post observed, such was not happening for SCC for instance as the most senior do not what what the contents of the abstracts are.

Is Number 1 clear to all.?  Do we know how to do this

Adding columns for treasury info on abstracts, sharing and pnl; making work efficient for sharing and PNL

---------- Forwarded message ---------
From: Jorge Saguinsin <jorge@holygardens.ph>
Date: Tue, Jan 13, 2026 at 8:09 PM
Subject: Adding columns for treasury info on abstracts, sharing and pnl
To: Madel Holy Gardens <mrss@holygardens.ph>

Memorandum:

To:   Ms  CCS

        Ms. Gladys

        

cc:  Ms Madel

Date:   January 13, 2026

SUBJECT;   ADDITIONAL COLUMNS FOR ABSTRACTS

1.  Treasury

     1.  Total collections

     less 2.   Bank deposits  reference numbers by customers

                  Bank deposit by HG staff

            3.  Cash on hand

                 Cash breakdown

                 1000 x

                   500 x

                   200 x

                   100 x

                     50 x

                     20 x

                     10 x

                       5 x

                       1 x

      4.  Summary

          Total collections=

          Less:  customer deposits

                     HG deposit

          = cash on hand (supported by pics video if possible

        Memorial park collection

        IS

       Other cash receipts

      TOTAL

2.  SHARING MODULE

     (xls with formula)

     less:    52%  (per account)

   (less COGS) as in phase 2 of HGGMP

     =        Amount for sharing

      x    __% for the developer =

      x    __% for the land owner

   So that daily we can know all ready the sharing

   LET US DO THIS DAILY FOR SUBMISSION 

3.  PNL module

      =  Our share

     Less COGS per square meter P3,500

                                                  12 mos ma                        24 mos                           36 mos                       48 mos                    60mos

 

              Lawn       8,750           729.16                           364.60                             243.05                          182.30                    145.85             

              SSN      35,000           291.70                        1,458,35                             972.25                          729.20                     583.35

              GE      105,000        8,750.00                        4,375.00                          2,917.00                       2,187.50                  1,750.00

    Summary:

     Our share (%) 

    Less:   COGS

   Our  GP (from whence we deduct OE and Interest and taxes)

For discussion and compliance

HENCE THE URGENT NEED TO HIRE SFC FOR EVERY SBU...

(GREAT WORK FOR CALAPAN FOR BEING ABLE TO ATTRACT APPLICANTS)